mysql操作数据库总结sql语句总结

复制表 create table erp_wangwangcopy select * from erp_wangwang;查询失败的条目倒序SELECT * FROM `weixin_faild_record` ORDER BY `send_time` desc;查询大于1的回头客订单select tid,buyer_nick  from jdp_tb_trade  where buyer_nick in(select buyer_nick from jdp_tb_trade group by buyer_nick having count(*)>1) ;$sql ="select * from jdp_tb_trade where status in('TRADE_FINISHED','WAIT_SELLER_SEND_GOODS','WAIT_BUYER_CONFIRM_GOODS') and jdp_modified between '".$start_time."' and '".$current_time."'";select uid,FORMAT(sum(money),2) as moneys,status from wx_lottery_win where check_code!='已兑奖' and lottery_date BETWEEN '2016-09-20' and '2016-12-16' GROUP BY uid HAVING moneys >=1UPDATE erp_wangwang SET wx_nc=wx_nc+11 WHERE  wangwang_no='tb74707632' AND open_id='xxxxxxxxxxxxx';UPDATE erp_wangwang SET wx_nc=wx_nc+11 WHERE  wangwang_no='测试账号315061897' AND open_id='xxxxxxxxxxxxx';insert into erp_wangwangbanksave select * from erp_wangwang;INSERT INTO `erp_wangwangbanksave`(`wangwang_no` ,`wx_no` ,`wx_nc` ,`nums` ,`open_id` ,`tid` ,`is_zz` ,`is_bj` ,`is_wh` ,`is_yy` ) SELECT `wangwang_no` ,`wx_no` ,`wx_nc` ,`nums` ,`open_id` ,`tid` ,`is_zz` ,`is_bj` ,`is_wh` ,`is_yy`  from `erp_wangwang` WHERE `wangwang_no` ='测试315061897'UPDATE erp_wangwangbanksave es , erp_wangwang ew SET es.wx_no=ew.wx_no,es.wx_nc=ew.wx_nc,es.nums=ew.nums,es.open_id=ew.open_id,es.tid=ew.tid,es.is_zz=ew.is_zz,es.is_bj=ew.is_bj,es.is_wh=ew.is_wh,es.is_yy=ew.is_yy WHERE es.wangwang_no=ew.wangwang_no and es.wangwang_no='{$wangwang_no}';  $sql ="select a.wx_no,a.wx_nc,a.nums,a.open_id,b.tid,b.buyer_nick,b.fk_status,b.jdp_response,b.created,b.end_time,b.modified from  erp_wangwang a left join jdp_tb_trade b on a.wangwang_no=b.buyer_nick where  b.status in('TRADE_FINISHED') and b.buyer_nick='".$wangwang_no."' and b.end_time between '".$start_time."' and '".$end_time."' order by b.fk_status asc,case b.fk_status when 1 then b.end_time end desc,case b.fk_status when 0 then b.end_time end desc  , b.buyer_nick  desc limit ".($parames['page']-1)*$parames['per_page_n'].",".$parames['per_page_n'];