02 2015 档案

MySQL修改root密码的多种方法
摘要：不知道在cmd模式下是不是区分大小写，我大写成功了，小写没成功，不知是我拼写的错误，还是区分大小写！！？？方法1： 用SET PASSWORD命令 mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpa... 阅读全文
posted @ 2015-02-05 11:17 潇潇留客 阅读(123) 评论(0) 推荐(0)
mysql 数据表中查找重复记录
摘要：select mobile_phone,count(*) as count from lawyer group by mobile_phone having count>1; 阅读全文
posted @ 2015-02-04 15:17 潇潇留客 阅读(135) 评论(0) 推荐(0)