2016.5.10 随笔——SQL语句 

 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 ;

 

posted @ 2016-05-10 19:39  zzfufuyy  阅读(109)  评论(0)    收藏  举报