摘要:
$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)

浙公网安备 33010602011771号