随笔分类 - MySQL / MySQL函数
字符串函数-STRCMP
摘要:MySQL5.7官网:https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html#function_strcmp STRCMP(expr1,expr2) ``` STRCMP(参数1,参数2) 如果字符串相同返回0
日期函数-DATADIFF
摘要:MySQL5.7官网:https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_datediff DATEDIFF(expr1,expr2) ``` DATEDIFF(expr1,expr2) 返回 e