MySQL Data Types


CHAR String (0 - 255)
VARCHAR String (0 - 255)
TINYTEXT String (0 - 255)
TEXT String (0 - 65535)
BLOB String (0 - 65535)
MEDIUMTEXT String (0 - 16777215)
MEDIUMBLOB String (0 - 16777215)
LONGTEXT String (0 - 429496­7295)
LONGBLOB String (0 - 429496­7295)
TINYINT x Integer (-128 to 127)
SMALLINT x Integer (-32768 to 32767)
MEDIUMINT x Integer (-8388608 to 8388607)
INT x Integer (-2147­483648 to 214748­3647)
BIGINT x Integer (-9223­372­036­854­775808 to 922337­203­685­477­5807)
FLOAT Decimal (precise to 23 digits)
DOUBLE Decimal (24 to 53 digits)
DECIMAL "­DOU­BLE­" stored as string
DATE YYYY-MM-DD
DATETIME YYYY-MM-DD HH:MM:SS
TIMESTAMP YYYYMM­DDH­HMMSS
TIME HH:MM:SS
ENUM One of preset options
SET Selection of preset options

 

MySQL Mathematical Functions

ABS COS
SIGN SIN
MOD TAN
FLOOR ACOS
CEILING ASIN
ROUND ATAN, ATAN2
DIV COT
EXP RAND
LN LEAST
LOG, LOG2, LOG10 GREATEST
POW DEGREES
POWER RADIANS
SQRT TRUNCATE
PI

 

MySQL String Functions

ASCII SUBSTRING
ORD MID
CONV SUBSTRING_INDEX
BIN LTRIM
OCT RTRIM
HEX TRIM
CHAR SOUNDEX
CONCAT SPACE
CONCAT_WS REPLACE
LENGTH REPEAT
CHAR_LENGTH REVERSE
BIT_LENGTH INSERT
LOCATE ELT
INSTR FIELD
LPAD LCASE
RPAD UCASE
LEFT LOAD_FILE
RIGHT QUOTE

 

MySQL Grouping Functions

AVG MAX
BIT_AND STD
BIT_OR STDDEV
COUNT SUM
GROUP_­CONCAT VARIANCE
MIN

 

MySQL Date and Time Functions

DAYOFWEEK DATE_SUB
WEEKDAY ADDDATE
DAYOFMONTH SUBDATE
DAYOFYEAR EXTRACT
MONTH TO_DAYS
DAYNAME FROM_DAYS
MONTHNAME DATE_F­ORMAT
QUARTER TIME_F­ORMAT
WEEK CURREN­T_DATE
YEAR CURREN­T_TIME
YEARWEEK NOW
HOUR SYSDATE
MINUTE UNIX_T­IME­STAMP
SECOND FROM_U­NIXTIME
PERIOD_ADD SEC_TO­_TIME
PERIOD­_DIFF TIME_T­O_SEC
DATE_ADD

 

MySQL Miscellaneous Functions

BIT_COUNT DES_EN­CRYPT
DATABASE DES_DE­CRYPT
USER LAST_I­NSE­RT_ID
SYSTEM­_USER FORMAT
SESSIO­N_USER VERSION
CURREN­T_USER CONNEC­TION_ID
PASSWORD GET_LOCK
OLD_PA­SSWORD RELEAS­E_LOCK
ENCRYPT IS_FRE­E_LOCK
DECODE BENCHMARK
MD5 INET_NTOA
SHA1 INET_ATON
AES_EN­CRYPT FOUND_ROWS
AES_DE­CRYPT STRCMP