测试环境常用sql

[douzi8]

数据库软件: Sequel pro

1. 查找用户

   select * from lcb_db.us_user where mobile ='15821907685';

2. 查看钱包详细 把total_amount，available_amount改成一样，即可更新余额

   select * from lcb_wallet_db.mem_member   where outer_related_id= {userid}
   select * from lcb_wallet_db.mem_member_account where member_id={钱包会员id};

   如果第一次充钱没有记录，需先创建一个充值记录 http://m2.lechebang.cn/wallet/index

3. 删掉车库所有的车子

   select * from lcb_db.mc_my_car where user_id={userid};
   update lcb_db.mc_my_car set deleted =1 where user_id={userid};

4. 查找短信记录

   SELECT * FROM lcb_db.`sms_log` WHERE mobiles={mobile} ORDER BY id DESC LIMIT 1;

5. 自驾游取消报名

   delete from lcb_travel_db.travel_driving_travelling where mobile='';