Description:
when execute a wrong sql,mysql execute success and get error result
see blow step
How to repeat:
mysql> select * from user_bought_order where order_id='lxzx1602261502584900'\G *************************** 1. row ***************************
order_id: lxzx1602261502584900
user_id: 34
address_id: 0
order_status: 2
create_time: 1456470178
orig_price: 2
order_price: 1
express_price: 0
pay_time: 1456568975
express_company:
express_out_id:
province:
city:
area:
address:
mobile:
name:
post_code:
1 row in set (0.00 sec)
mysql> update user_bought_order set order_status=1 and pay_time=0 where order_id='lxzx1602261502584900';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from user_bought_order where order_id='lxzx1602261502584900'\G *************************** 1. row ***************************
order_id: lxzx1602261502584900
user_id: 34
address_id: 0
order_status: 0
create_time: 1456470178
orig_price: 2
order_price: 1
express_price: 0
pay_time: 1456568975
express_company:
express_out_id:
province:
city:
area:
address:
mobile:
name:
post_code:
1 row in set (0.00 sec)
Description: when execute a wrong sql,mysql execute success and get error result see blow step How to repeat: mysql> select * from user_bought_order where order_id='lxzx1602261502584900'\G *************************** 1. row *************************** order_id: lxzx1602261502584900 user_id: 34 address_id: 0 order_status: 2 create_time: 1456470178 orig_price: 2 order_price: 1 express_price: 0 pay_time: 1456568975 express_company: express_out_id: province: city: area: address: mobile: name: post_code: 1 row in set (0.00 sec) mysql> update user_bought_order set order_status=1 and pay_time=0 where order_id='lxzx1602261502584900'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from user_bought_order where order_id='lxzx1602261502584900'\G *************************** 1. row *************************** order_id: lxzx1602261502584900 user_id: 34 address_id: 0 order_status: 0 create_time: 1456470178 orig_price: 2 order_price: 1 express_price: 0 pay_time: 1456568975 express_company: express_out_id: province: city: area: address: mobile: name: post_code: 1 row in set (0.00 sec)