1,假设一起更新3号顾客的发票情况
这时候需要用到更新多行
update invoices
set
payment_total=invoice_total*0.5,
payment_date=due_date
where client_id=3
出现了警告
21:20:35 update invoices set payment_total=invoice_total*0.5, payment_date=due_date where client_id=3 5 row(s) affected, 4 warning(s): 1265 Data truncated for column 'payment_total' at row 1 1265 Data truncated for column 'payment_total' at row 2 1265 Data truncated for column 'payment_total' at row 3 1265 Data truncated for column 'payment_total' at row 4 Rows matched: 5 Changed: 5 Warnings: 4 0.032 sec
如何解决:
edit-preference-取消勾选safe update
这可以防止你意外更新或者删除一些表的记录
然后复制代码,关闭这个页面,重新进入workbench
会发现原表都已经改了。
2,也可以用In,如下3,4客户的发票信息会被更改。
update invoices
set
payment_total=invoice_total*0.5,
payment_date=due_date
where client_id=3
3,如果想要更新表中的所有顾客的发票,还是按照刚才的设定,那么
where这句可以删除,即
update invoices
set
payment_total=invoice_total*0.5,
payment_date=due_date
4,练习:
答案:
update customers
set
points=points+50
where birth_date<'1990-01-01'