After followed the steps in Mosh’s class about delete multiple rows, I still failed.
here is the steps. Thanks a lot for helping me !
use sql_invoicing;
update invoices
Set
payment_total = invoice_total * 0.5,
payment_date = due_date
where client_id = 3
16:03:08 update invoices Set payment_total = invoice_total * 0.5, payment_date = due_date where client_id = 3 0 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: 0 Warnings: 4 0.00089 sec