后端server使用数据库

1.远程连接：mysql -h 10.99.199.68 -P3306 -uroot -proot -A

use novel_trade;
select *from bean_user_info_new where uid = 868971573

show tables;
select *from novel_reg_info_new where uid = 868971573;

修改7天有效期的sql
                                             此处英文双引号，需要改成单引号
update bean_user_info_new set coupon_detail = "{"5":[[0,"20170518","20170527",33]]}" where id = 131 and uid = 868971573；

update bean_user_info_new set coupon_detail = "{"5":[[0,"20180518","20180527",33]]}" where id = 130 and uid = 868971573；

删除记录

delete from bean_user_info_new where uid = 868971573；

根据用户的uid来处理