1.数学函数
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/140e656a65785ccd3bf3b060bcf7a51b.png)
2.字符串函数
SELECT CHAR_LENGTH('ABC');
SELECT LENGTH('你好啊');
SELECT CONCAT('A', 'B', 'C');
SELECT CONCAT('A', 'B', 'C', NULL);
SELECT CONCAT_WS('-', 'a', 'b', 'c');
SELECT CONCAT_WS('-', 'a', 'b', 'c', NULL);
SELECT CONCAT_WS(NULL, 'a', 'b', 'c');
SELECT UPPER('hello king'), UCASE('hello mysql'), LOWER('HELLO KING'), LCASE('HELLO MYSQL');
SELECT REVERSE('ABC');
SELECT LEFT('HELLO', 2), RIGHT('HELLO', 2);
SELECT LPAD('ABC', 10, '?');
SELECT RPAD('ABC', 10, '?');
SELECT TRIM(' ABC ');
SELECT LTRIM(' ABC');
SELECT RTRIM('ABC ');
SELECT REPEAT('hello', 3);
SELECT REPLACE('HELLO KING', 'KING', 'QUEEN');
SELECT SUBSTRING('ABCDEFG', 1, 3);
SELECT STRCMP('A', 'B');
SELECT STRCMP('A', 'A');
SELECT STRCMP('C', 'B');
3.日期时间函数
SELECT CURDATE(), CURRENT_DATE();
SELECT CURTIME(), CURRENT_TIME();
SELECT NOW(), CURRENT_TIMESTAMP(), SYSDATE();
SELECT MONTH('2022-02-15');
SELECT MONTH(CURDATE()), MONTHNAME(CURDATE());
SELECT DAYNAME(NOW());
SELECT DAYOFWEEK(NOW());
SELECT WEEK(NOW());
SELECT YEAR(NOW()), MONTH(NOW()), DAY(NOW()), HOUR(NOW()), MINUTE(NOW()), SECOND(NOW());
SELECT DATEDIFF('2022-1-21', '2022-2-8');
4.其他常用函数
SELECT VERSION(), CONNECTION_ID();
SELECT DATABASE(), SCHEMA();
SELECT USER(), CURRENT_USER(), SYSTEM_USER(), SESSION_USER();
SELECT LAST_INSERT_ID();
SELECT MD5('MYSQL');
SELECT LENGTH(MD5('MYSQL'));