SQL

香港项目
select user.*,account.* from user join account on user.id=rating_points.id;
select user.*,orders.* from user left join orders on user.id=orders.id;
select user.*,account.* from user left join account on user.id=user_id WHERE rating_points="399" OR rating_points="299";
#vip记录
select user.*,account.* from user left join account on user.id=user_id WHERE rating_points!="0"
#充值记录
SELECT user.*,recharge.*from user left join recharge on user.id =user_id WHERE amount!="0";
#汇款记录
SELECT remittance.*,user.*from remittance left join user on user.id =user_id WHERE amount!="0";

SELECT recharge.*,user.*from recharge,user where user.id=user_id;
#用户记录
select user.*,account.* from user,account where user.id=account.id;
#汇款记录
SELECT * FROM `mumcash_user`.`remittance` AS mr LEFT JOIN mumcash_user.`user` as mu ON mu.id = mr.user_id LEFT JOIN mumcash_user.receiver AS mre ON mr.receiver_id = mre.id LIMIT 0,2900;
#购买记录
SELECT `user`.*,account_pay.*from `user` left join account_pay on user.id = user_id WHERE amount!="0";

SELECT user.id, user.mobile, account.total, account.rating_points, account.profit FROM `user` LEFT JOIN account ON user.id = account.user_id ORDER BY user.id asc;
#倒叙
SELECT user.id, user.mobile, account.total, account.rating_points, account.profit FROM `user` LEFT JOIN account ON user.id = account.user_id ORDER BY user.id DESC;

#购买记录
SELECT user.id, user.mobile, account_pay.amount, account_pay.created_at,account_pay.voucher, account_pay.state,account_pay.biz_type,account_pay.remarks FROM `user` LEFT JOIN account_pay ON user.id = account_pay.user_id WHERE amount!=0 ORDER BY user.id ;

#账户信息查询
SELECT user.id, user.mobile,user.id_card,user.enabled,user.surname,user.name, user.created_at,user.parent_id,account.total, account.rating_points, account.profit,account.frozen_total FROM `user` LEFT JOIN account ON user.id = account.user_id ORDER BY user.id asc;
#充值记录
SELECT user.id, user.mobile, recharge.created_at,recharge.state, recharge.bank, recharge.amount, recharge.voucher FROM `user` LEFT JOIN recharge on user.id=recharge.user_id WHERE amount!=0 ORDER BY recharge.id asc;
#汇款记录
SELECT * FROM `mumcash_user`.`remittance` AS mr LEFT JOIN mumcash_user.`user` as mu ON mu.id = mr.user_id LEFT JOIN mumcash_user.receiver AS mre ON mr.receiver_id = mre.id LIMIT 0,4900;

update token set token = "\"{\\\"code\\\":\\\"R51C04EL3\\\"}\"" WHERE id = 119

 

update user set surname = 'ABUJAN',  name ='CHARELYNC' WHERE id = 1119;