tinyint
smallint
mediumint
int
integer
bigint
float
double
real
decimal
numeric
date
datetime
timestamp
time
year
char
bit
bool
varchar
tinyblob
tinytext
blob
text
mediumblob
mediumtext
longblob
longtext
enum
set
fulltext
ascii
ord
conv
bin
oct
hex
char
concat
concat_ws
length
octet_length
char_length
character_length
locate
position
instr
lpad
rpad
left
right
substring
mid
substring_index
ltrim
rtrim
trim
soundex
space
replace
repeat
reverse
insert
elt
field
find_in_set
make_set
export_set
lcase
lower
ucase
upper
load_file
strcmp
abs
sign
mod
floor
ceiling
round
exp
log
log10
pow
power
sqrt
cos
sin
tan
asin
atan
atan2
cot
rand
least
greatest
degrees
radians
truncate
dayofweek
weekday
dayofmonth
dayofyear
month
dayname
monthname
quarter
week
year
yearweek
hour
minute
second
period_add
period_diff
date_add
date_sub
adddate
subdate
extract
to_days
from_days
date_format
time_format
curdate
current_date
curtime
current_time
now
sysdate
current_timestamp
unix_timestamp
from_unixtime
sec_to_time
time_to_sec
database
user
system_user
session_user
password
encrypt
encode
decode
md5
last_insert_id
format
version
connection_id
get_lock
release_lock
benchmark
inet_ntoa
inet_aton
master_pos_wait
COUNT
AVG
MIN
MAX
SUM
BIT_OR
BIT_AND