mysql
Free丶
这个作者很懒,什么都没留下…
展开
-
mysql视图
12月视图 select '12' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 12) month),'%Y-%m') AS `MONTH` union all select '11' AS `id`,date_format((curdate() + interval (-(month(curdate())) + 11) month),'%Y-%m') AS `MONTH` union all select '10' AS原创 2021-07-08 09:13:02 · 48 阅读 · 0 评论 -
mysql去重
DELETE FROM t_account_center WHERE USERNAME IN( SELECT t.USERNAME FROM( SELECT USERNAME FROM t_account_center GROUP BY USERNAME HAVING COUNT(*)>1 ) t )AND id NOT IN( SELECT t.id FROM( SELECT MAX(id) AS id FROM t_account_cente原创 2021-07-08 09:10:26 · 52 阅读 · 0 评论 -
mysql权限设置
用户授权 GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE,EXECUTE ON *.* TO 'smarttourist_app'@'%' IDENTIFIED BY 'O5l@+oDqxl'; 刷新权限 FLUSH PRIVILEGES; 查看用户权限 SHOW GRANTS FOR 'smarttourist_app'@'%';原创 2021-07-08 09:07:44 · 38 阅读 · 0 评论