Mysql Cheat Sheet
ADVERTISEMENT
1MySQL Cheat Sheet
by
Dave Child (DaveChild)
via
MySQL Data Types
MySQL Mathematical Functions
MySQL Date and Time Functions
CHAR
String (0 - 255)
ABS
COS
DAYOFWEEK
DATE_SUB
VARCHAR
String (0 - 255)
SIGN
SIN
WEEKDAY
ADDDATE
TINYTEXT
String (0 - 255)
MOD
TAN
DAYOFMONTH
SUBDATE
TEXT
String (0 - 65535)
FLOOR
ACOS
DAYOFYEAR
EXTRACT
BLOB
String (0 - 65535)
CEILING
ASIN
MONTH
TO_DAYS
MEDIUMTEXT
String (0 - 16777215)
ROUND
ATAN, ATAN2
DAYNAME
FROM_DAYS
MEDIUMBLOB
String (0 - 16777215)
DIV
COT
MONTHNAME
DATE_FORMAT
LONGTEXT
String (0 - 4294967295)
EXP
RAND
QUARTER
TIME_FORMAT
LONGBLOB
String (0 - 4294967295)
LN
LEAST
WEEK
CURRENT_DATE
TINYINT x
Integer (-128 to 127)
LOG, LOG2, LOG10
GREATEST
YEAR
CURRENT_TIME
SMALLINT x
Integer (-32768 to 32767)
POW
DEGREES
YEARWEEK
NOW
MEDIUMINT x
Integer (-8388608 to 8388607)
POWER
RADIANS
HOUR
SYSDATE
INT x
Integer (-2147483648 to
SQRT
TRUNCATE
MINUTE
UNIX_TIMESTAMP
2147483647)
PI
SECOND
FROM_UNIXTIME
BIGINT x
Integer (-9223372036854775808
PERIOD_ADD
SEC_TO_TIME
to 9223372036854775807)
MySQL String Functions
PERIOD_DIFF
TIME_TO_SEC
FLOAT
Decimal (precise to 23 digits)
ASCII
MID
DATE_ADD
DOUBLE
Decimal (24 to 53 digits)
ORD
SUBSTRING_INDEX
DECIMAL
"DOUBLE" stored as string
MySQL Control Flow Functions
CONV
LTRIM
DATE
YYYY-MM-DD
BIN,OCT,HEX
RTRIM
IF
NULLIF
DATETIME
YYYY-MM-DD HH:MM:SS
CHAR
TRIM
IFNULL
TIMESTAMP
YYYYMMDDHHMMSS
CONCAT
SOUNDEX
MySQL Miscellaneous Functions
TIME
HH:MM:SS
CONCAT_WS
SPACE
ENUM
One of preset options
BIT_COUNT
DES_ENCRYPT
LENGTH
REPLACE
SET
Selection of preset options
DATABASE
DES_DECRYPT
CHAR_LENGTH
REPEAT
USER
LAST_INSERT_ID
Integers (marked x) that are "UNSIGNED" have the
BIT_LENGTH
REVERSE
same range of values but start from 0 (i.e., an
SYSTEM_USER
FORMAT
LOCATE
INSERT
UNSIGNED TINYINT can have any value from 0 to
SESSION_USER
VERSION
INSTR
ELT
255).
CURRENT_USER
CONNECTION_ID
LPAD
FIELD
PASSWORD
GET_LOCK
MySQL Type Conversion
RPAD
LCASE
OLD_PASSWORD
RELEASE_LOCK
BINARY 'string'
LEFT
UCASE
ENCRYPT
IS_FREE_LOCK
CAST (expression AS datatype)
RIGHT
LOAD_FILE
DECODE
BENCHMARK
CONVERT (expression, datatype)
SUBSTRING
QUOTE
MD5
INET_NTOA
MySQL Grouping Functions
SHA1
INET_ATON
AVG
MAX
AES_ENCRYPT
FOUND_ROWS
BIT_AND
STD
AES_DECRYPT
STRCMP
BIT_OR
STDDEV
COUNT
SUM
GROUP_CONCAT
VARIANCE
MIN
Cheatographer
Cheat Sheet
Sponsor
Dave Child (DaveChild)
Envoy, for simple and effective bug management.
This cheat sheet was published on 19th October,
2011 and was last updated on 20th October, 2011.
Try it free!
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education