![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
老蚊子
这个作者很懒,什么都没留下…
展开
-
mysql权限设置
权限设置: chown mysql:mysql -R /var/lib/mysql mysql -u root -p grant all privileges on *.* to root@'%' identified by 'Password01!' with grant option; alter user 'root'@'%' identified by 'Password01!'; flush privileges;原创 2021-11-21 17:17:46 · 770 阅读 · 0 评论 -
mysql自动计数
set @data_date := null; set @num := 1; SET @activity_name :=null; set @num1 := 1; SELECT data_date, activity_name,activity_pay_amount, if(@data_date IS null or @data_date <> data_date, @num :=...原创 2020-01-08 18:21:40 · 412 阅读 · 0 评论