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 – 4294967295)
|
LONGBLOB
|
String (0 – 4294967295)
|
TINYINT x
|
Integer (-128 to 127)
|
SMALLINT x
|
Integer (-32768 to 32767)
|
MEDIUMINT x
|
Integer (-8388608 to 8388607)
|
INT x
|
Integer (-2147483648 to 2147483647)
|
BIGINT x
|
Integer (-9223372036854775808 to 9223372036854775807)
|
FLOAT
|
Decimal (precise to 23 digits)
|
DOUBLE
|
Decimal (24 to 53 digits)
|
DECIMAL
|
“DOUBLE” stored as string
|
DATE
|
YYYY-MM-DD
|
DATETIME
|
YYYY-MM-DD HH:MM:SS
|
TIMESTAMP
|
YYYYMMDDHHMMSS
|
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 Date and Time Functions
DAYOFWEEK
|
DATE_SUB
|
WEEKDAY
|
ADDDATE
|
DAYOFMONTH
|
SUBDATE
|
DAYOFYEAR
|
EXTRACT
|
MONTH
|
TO_DAYS
|
DAYNAME
|
FROM_DAYS
|
MONTHNAME
|
DATE_FORMAT
|
QUARTER
|
TIME_FORMAT
|
WEEK
|
CURRENT_DATE
|
YEAR
|
CURRENT_TIME
|
YEARWEEK
|
NOW
|
HOUR
|
SYSDATE
|
MINUTE
|
UNIX_TIMESTAMP
|
SECOND
|
FROM_UNIXTIME
|
PERIOD_ADD
|
SEC_TO_TIME
|
PERIOD_DIFF
|
TIME_TO_SEC
|
DATE_ADD
|
MySQL Miscellaneous Functions
BIT_COUNT
|
DES_ENCRYPT
|
DATABASE
|
DES_DECRYPT
|
USER
|
LAST_INSERT_ID
|
SYSTEM_USER
|
FORMAT
|
SESSION_USER
|
VERSION
|
CURRENT_USER
|
CONNECTION_ID
|
PASSWORD
|
GET_LOCK
|
OLD_PASSWORD
|
RELEASE_LOCK
|
ENCRYPT
|
IS_FREE_LOCK
|
DECODE
|
BENCHMARK
|
MD5
|
INET_NTOA
|
SHA1
|
INET_ATON
|
AES_ENCRYPT
|
FOUND_ROWS
|
AES_DECRYPT
|
STRCMP
|
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
|
Aucun commentaire:
Enregistrer un commentaire