常用sql函数

select ABS(-2); 返回绝对值

select CEIL(2.5);返回大于参数的整数

select FLOOR(3.5);获得小于参数的整数

select USER();获得mysql用户名

select MOD(25,7); 获得余数

select AVG(age) from student; 求平均值

select SUM(age) from student; 求和

select Length(stu_name) from student where id=3; 字符串长度

select ASCII( stu_name) from student where id=3; 获得字符串ASCII码

select LEFT(stu_name,5)from student where id=3; 输出字符串前五个字符

select RIGHT(stu_name,5)from student where id=3; 获得 字符串后五位

select REPLACE(stu_name,‘z’,‘c’)from student where id=3;修改字符串

select REPEAT(stu_name,5)from student where id=2;复制字符串

select REVERSE(stu_name)from student where id=1;字符串列排序

select insert(stu_name,2,3,‘is’)from student where id=1;将字符串第二位及其后两位改为is

select MONTHNAME(‘1024-5-6’);获得月份

select TRIM(’ SADFAS’);去除字符串的空格

select DAYOFWEEK(now());获得现在是周几，1是周日…7是周一

select DAYOFMONTH(now());获得现在是几号

select DAYNAME(now());获得现在是周几