mysql函数记录

substring_index(str,str1,a) 截取字符串
locate(substr,String)
weekday(now()) 周一为0，周日为6
adddate(NOW(),2) 后天
group_concat() 拼接分组数据，默认逗号分隔
date_format(now(),'%Y/%m/%d') 格式化日期
substr(str, a, b) 截取字符串 下标从1开始算，不是0，从a开始截取b个字符
trim() 
ifnull(expression, alt_value))
CURDATE()

 

ip地址和整型之间转换，最大转化为255.255.255.255

mysql> select INET_ATON('192.168.88.123');
+-----------------------------+
| INET_ATON('192.168.88.123') |
+-----------------------------+
|                  3232258171 |
+-----------------------------+
1 row in set (0.00 sec)
​
mysql> select INET_NTOA('3232258171');
+-------------------------+
| INET_NTOA('3232258171') |
+-------------------------+
| 192.168.88.123          |
+-------------------------+
1 row in set (0.00 sec)