一、字符函数
CONCAT():字符连接CONCAT_WS():使用指定分隔符进行字符连接FORMAT():数字格式化LOWER():转化成小写字母UPPER():转化成大写字母LEFT():获取左侧字符RIGHT():获取右侧字符LENGTH():获取字符串长度LTRIM():删除前导空格RTRIM():删除后续空格SUBSTRING():字符串截取【NOT】LIKE:模式匹配REPLACE():字符串替换 mysql> SELECT CONCAT('SUN','*','YUE','*','RU'); +----------------------------------+ | CONCAT('SUN','*','YUE','*','RU') | +----------------------------------+ | SUN*YUE*RU | +----------------------------------+ 1 row in set (0.00 sec)mysql> SELECT CONCAT_WS('&','SUN','YUE','RU');+---------------------------------+| CONCAT_WS('&','SUN','YUE','RU') |+---------------------------------+| SUN&YUE&RU |+---------------------------------+1 row in set (0.00 sec)mysql> SELECT FORMAT(1223456.78,1);+----------------------+| FORMAT(1223456.78,1) |+----------------------+| 1,223,456.8 |+----------------------+1 row in set (0.00 sec)...
二、数值运算符与函数
CEIL()进一取整DIV整数取整FLOOR()舍一取整MOD 取余(取模)ROUND()四舍五入TRUNCATE()数字截取三、比较运算符与函数
[NOT] BETWEEN...AND...[NOT] IN()IS [NOT] NULL四、日期时间函数
NOW()CURDATE()CURTIME()DATE_ADD()DATEDIFF()DATE_FORMAT()http://www.w3school.com.cn/sql/sql_dates.asp
五、信息函数
CONNECTION_ID()连接idDATABASE()当前数据库LAST_INSERT_ID()最后插入记录的ID号USER()当前用户VERSION()版本信息六、聚合函数
AVG()COUNT()MAX()MIN()SUM()转载于:https://www.cnblogs.com/mesunyueru/p/9020046.html