SQL
南瓜派PumpkinPie
这个作者很懒,什么都没留下…
展开
-
mysql忘记密码后如何重置密码
macOS terminal mysql 8.0 How to reset new password without old one #1. stop mysql /usr/local/mysql/support-files/mysql.server stop #2.Run the server in safe mode with privilege bypass: sudo mysqld_...原创 2020-03-04 04:55:59 · 342 阅读 · 0 评论 -
SQL分组统计
全国各省份人口数排前三的城市 思路:先按照省份分组,再组内按照人口数排序取前三 <!--mysql--> set @num = 0, @class = ''; select * from ( select p.*, @num := if(@class=province, @num+1,1) as rank, @class := p.provinc...转载 2019-02-28 17:45:21 · 1146 阅读 · 0 评论