上一页 1 ··· 26 27 28 29 30
摘要: $sql="SELECT peisonghao FROM ecs_order_info_ly GROUP BY peisonghao HAVING COUNT(*) >1"; $rlt=$GLOBALS['db']->query($sql); while($data=$GLOBALS['db']-> 阅读全文
posted @ 2016-12-21 16:10 Microtiger 阅读(403) 评论(0) 推荐(0)
摘要: update user set host = '%' where user = 'root'; update user set password=password('wangxiaohu') where user='root'; update table1 SET title=replace(tit 阅读全文
posted @ 2016-12-21 16:09 Microtiger 阅读(127) 评论(0) 推荐(0)
摘要: 设置数据库的时候 qq 号如果用整型,设置成UNSIGNED,不然超过一定数值就错误 UPDATE `sao_qq` SET qq_num = REPLACE ( qq_num, '@qq.com', '' ); delete from sao_qq where qq_num not like '% 阅读全文
posted @ 2016-12-21 16:09 Microtiger 阅读(394) 评论(0) 推荐(0)
上一页 1 ··· 26 27 28 29 30