没有系统学过sql语句,每次有新的sql语句使用后总结下来,发现常用的SQL就会了。
例如更新某个字段值:update b_teluser set shopnum=100 where live=1;
例如两个表联合查询:
SELECT sum(buy_id) as buy_id,pay_bill.pay_bank,pay_bill.buy_time, b_userinfo.* from pay_bill LEFT join b_userinfo on b_userinfo.openid=pay_bill.buy_openid WHERE pay_bill.is_paid=2 group by pay_bill.buy_openid order by pay_bill.buy_time desc LIMIT ".$pageMin.",".$pageMax.";
结果如图
转载于:https://my.oschina.net/u/3600061/blog/1523300