update invoices
set payment_total = invoice_total * 0.5, payment_date = due_date
where invoice_id = 3
I wrote the code exactly as taught.
but why it’s giving me a warning ?
16:33:20 update invoices set payment_total = invoice_total * 0.5, payment_date = due_date where invoice_id = 3 0 row(s) affected, 1 warning(s): 1265 Data truncated for column ‘payment_total’ at row 1 Rows matched: 1 Changed: 0 Warnings: 1 0.000 sec