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 · 3062 阅读 · 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 · 234 阅读 · 0 评论