qq_35575480的博客

1、mysql 添加用户访问权限格式：grant all on *.* to 'root'@'192.168.0.%' identified by 'root'; 列子：grant all on db1.b1 to '用户'@'%' identified by '密码';授权root用户可以在任何 % ip下对db1数据库的b1表进行访问2、添加增、删、改、查权限，授权本机操作权限格式：grant select ,insert ,update,delete on *.* to 'root'

1、获取两个时间之间的天数select TIMESTAMPDIFF(DAY, '2020-03-20 23:59:00', '2020-03-25 00:00:00') as days;2、获取 两个时间之间的月份select TIMESTAMPDIFF(month, '2020-01-20 23:59:00', '2020-03-25 00:00:00') as months;3、获取两个时间之间的 时 分 秒时select TIMESTAMPDIFF(HOUR, '2020-03-2