在mysql workbench上更新多张表,按照要求取消了SQL_SAFE_UPDATES,也重启了软件,但还是报错
update invoices
set payment_total=invoice_total*0.5,
payment_date=due_date
where client_id=
(select client_id
from clients
where name= 'Myworks' )
报错结果
0 row(s) affected, 1 warning(s): 1265 Data truncated for column 'payment_total' at row 2 Rows matched: 1 Changed: 0 Warnings: 1