字符串函数和数学函数
SELECT ABS(-8);
SELECT CEILING(9.4);
SELECT FLOOR(9.4);
SELECT RAND();
SELECT SIGN(0);
SELECT CHAR_LENGTH('狂神说坚持就能成功');
SELECT CONCAT('我','爱','程序');
SELECT INSERT('我爱编程helloworld',1,2,'超级热爱');
SELECT LOWER('KuangShen');
SELECT UPPER('KuangShen');
SELECT LEFT('hello,world',5);
SELECT RIGHT('hello,world',5);
SELECT REPLACE('狂神说坚持就能成功','坚持','努力');
SELECT SUBSTR('狂神说坚持就能成功',4,6);
SELECT REVERSE('狂神说坚持就能成功'); /*反转
SELECT REPLACE(studentname,'周','邹') AS 新名字
FROM student WHERE studentname LIKE '周%';
日期和时间函数
SELECT CURRENT_DATE();
SELECT CURDATE();
SELECT NOW();
SELECT LOCALTIME();
SELECT SYSDATE();
SELECT YEAR(NOW());
SELECT MONTH(NOW());
SELECT DAY(NOW());
SELECT HOUR(NOW());
SELECT MINUTE(NOW());
SELECT SECOND(NOW());
– 数值函数
abs(x)
format(x, d)
ceil(x)
floor(x)
round(x)
mod(m, n)
pi()
pow(m, n)
sqrt(x)
rand()
truncate(x, d)
– 时间日期函数
now(), current_timestamp();
current_date();
current_time();
date('yyyy-mm-dd hh:ii:ss');
time('yyyy-mm-dd hh:ii:ss');
date_format('yyyy-mm-dd hh:ii:ss', '%d %y %a %d %m %b %j');
unix_timestamp();
from_unixtime();
– 字符串函数
length(string)
char_length(string)
substring(str, position [,length])
replace(str ,search_str ,replace_str)
instr(string ,substring)
concat(string [,...])
charset(str)
lcase(string)
left(string, length)
load_file(file_name)
locate(substring, string [,start_position])
lpad(string, length, pad)
ltrim(string)
repeat(string, count)
rpad(string, length, pad)
rtrim(string)
strcmp(string1 ,string2)
count()
sum();
max();
min();
avg();
group_concat()