ELTRENO.COM

Home

PHP

XSLT

JavaScript

ActionScript

MySQL

Unix

VI

Git

React

Day


Cheat sheets

webmasterworld

w3schools

w3c

php

mysql

Validate XHTML

Links

 

MySQL CheatSheet

mysql restore from dump

mysqldump

Numeric Types

Operators

Statistics

String Types

 

mysql restore from dumptop

mysq -u user -p dbname < backupfile.sql

mysqldumptop

mysqldump -u user -p dbname > backupfile.sql

Numeric Typestop

Type    Bytes Minimum Value    Maximum Value 
        (Signed/Unsigned)      (Signed/Unsigned) 

TINYINT   1   -128 127 
              0   255 

SMALLINT  2   -32768 32767 
              0      65535 

MEDIUMINT 3  -8388608 8388607 
             0        16777215 

INT       4  -2147483648 2147483647 
             0           4294967295 

BIGINT    8  -9223372036854775808     9223372036854775807 
             0                        18446744073709551615 

Operatorstop

BETWEEN ... AND ...     Check whether a value is within a range of values
COALESCE()              Return the first non-NULL argument
<=>                     NULL-safe equal to operator
=                       Equal operator
>=                      Greater than or equal operator
>                       Greater than operator
GREATEST()              Return the largest argument
IN()                    Check whether a value is within a set of values
INTERVAL()              Return the index of the argument that is less than the first argument
IS NOT NULL             NOT NULL value test
IS NULL	                NULL value test
ISNULL()                Test whether the argument is NULL
LEAST()                 Return the smallest argument
<=                      Less than or equal operator
<                       Less than operator
LIKE                    Simple pattern matching
NOT BETWEEN ... AND ...	Check whether a value is not within a range of values
!=, <>                  Not equal operator
NOT IN()                Check whether a value is not within a set of values
NOT LIKE                Negation of simple pattern matching
STRCMP()                Compare two strings

Statisticstop

# Get lis of all tables with row and length stats.

SHOW TABLE STATUS FROM DATABASE_NAME;

String Typestop

CHAR(0-255)
VARCHAR(0-255) in version < 5.0.3 
VARCHAR(0-65,535) in version > 5.0.3 

TINYTEXT(0-255)   (8-bit length)
TEXT(0-65535)   (16-bit length)
MEDIUMTEXT(0-16777215)   (24-bit length)
LONGTEXT(0-4294967295)   (32-bit length)

BINARY(0-255)
VARBINARY(0-255) in version < 5.0.3
VARBINARY(0-65,535) in version > 5.0.3 

ENUM type must contain 1 value from a specified list
ENUM('yes', 'no') //can contain the following
'yes'
'no'

SET Type  can contain 0 or more values from a specified list
SET('one', 'two') //can contain the following
''
'one'
'two'
'one,two'
 
 

Contact: [email protected]