https://blog.liuts.com/index.php zh-cn https://blog.liuts.com/post// <> Tue, 14 Aug 2007 15:11:02 +0000 https://blog.liuts.com/post// 查询双重的记录：
SELECT username FROM info where sex='1' GROUP BY 'username' HAVING count(*)>1;
二、Mysql添加权限
GRANT select,LOCK TABLES on database.* to user@localhost identified by '123456fdgdf#df';
三、Mysql追加权限
GRANT SELECT,INSERT,UPDATE,DELETE,INDEX ON database.* TO user@localhost;
四、Mysql删除权限REVOKE ALL on database.* FROM user@localhost;
REVOKE grant option on database.* FROM user@localhost;
五、PHP支持的密码格式
SET PASSWORD FOR user@localhost = OLD_PASSWORD('sdjfk345798');
Tags - mysql , 笔记 ]]> https://blog.liuts.com/post//#blogcomment <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://blog.liuts.com/post//#blogcomment