![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
CabinKeeper
勤奋造就天才,知识改变命运
展开
-
Mysql 查询用户2 的聊天记录列表
select * from wx_chat where create_time in (SELECT MAX(create_time) from wx_chat where receiver_id =2 or sender_id=2 GROUP BY CONCAT(if(sender_id>receiver_id,sender_id,rece原创 2017-05-08 15:44:14 · 3054 阅读 · 1 评论 -
Mysql修改root密码
Mysql修改root密码#查看数据库用户表;SELECT * FROM mysql.user;#查看用户root的字段,没有password字段时密码字段为authentication_string;SELECT * FROM USER WHERE USER=‘root’;#修改用户root的密码;UPDATE mysql.user SET authentication_string...原创 2018-12-26 10:34:10 · 230 阅读 · 0 评论