![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
xinqq163
这个作者很懒,什么都没留下…
展开
-
命令提示符还原MYSQL数据库
命令提示符还原MYSQL数据库 www.xinqq163.com mysql --default-character-set=gb2312 -u root -p123456 密码 use [数据库名] source source D:\1.sql 或者source source D:1.sql 用这样命令试试 mysql --default-character-set=utf8 -u原创 2012-04-25 09:59:39 · 570 阅读 · 0 评论 -
mysql之删除重复数据
//删除id重复的数据,适合id是手工主键 delete person as a from person as a, ( select *,min(id) from person group by id having count(1) > 1 ) as b where a.id = b.id //查找重复的,并且除掉最小的那个 dele转载 2012-04-26 15:31:40 · 582 阅读 · 0 评论 -
Navicat连接Mysql8报错:Client does not support authentication protocol requested by server;
https://www.cnblogs.com/zichuan/p/9203129.html转载 2019-04-12 11:29:30 · 281 阅读 · 0 评论