遇到的问题记录
liujingjie2010
这个作者很懒,什么都没留下…
展开
-
mysql语句内连接,左连接,右连接
select b.name,avg(salary) as avg_salary from staff a inner JOIN store b on a.store_id = b.store_id group by b.name order by avg_salary desc;select b.name,avg(salary) as avg_salary from staff ale...原创 2018-12-27 06:56:24 · 279 阅读 · 0 评论 -
navicat连接本地localhost 1251报错
1.先通过命令行进入mysql的root账户: C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -uroot -p 2.更改加密方式: ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; 3.更改密码:该例子中 12...原创 2018-12-24 14:07:52 · 956 阅读 · 1 评论