2016.5.10 随笔——SQL语句

最新推荐文章于 2024-06-20 11:07:41 发布

weixin_30299539

最新推荐文章于 2024-06-20 11:07:41 发布

阅读量56

点赞数

原文链接：http://www.cnblogs.com/zywhr/p/5479159.html

版权

 1 select * from user_extend where user_dbid >= 30001138 and user_dbid <= 30001137 + 10000 order by user_dbid;
 2 select * from account_info 
 3 select count(*) from account_info
 4 
 5 
 6 
 7 select * from user_extend a,
 8 (select user_dbid, sum(create_by) dzbl_id  from account_info group by user_dbid ) b
 9 where a.user_dbid = b.user_dbid and a.dzbl_id <> b.dzbl_id
10 
11 
12 update user_extend set dzbl_id = null where dzbl_id is not null;
13 delete from account_info where account_dbid <>495729307722223616 ;