数学运算
select abs(-1);
select ceiling(9.4);
select floor(9.4);
select rand();
select sign(-9);
字符串
select char_length('12345');
select concat('A','b','C');
select insert('ABCD',1,2,'WK');
select lower('aBcd');
select upper('aBcd');
select instr('abcd','b');
select replace('abc','b','c');
select substr('abcdef',1,2);
select reverse('abc');
时间和日期
select current_date();
select curdate();
select now();
select localtime();
select sysdate();
select year(now());
select month(now());
select minute(now());
select second(now());
系统
select user();
select version();
聚合函数
count
avg
sum
max
min
group by
having