SQL-complete-tutorial

1
UPDATE invoices
2
SET payment_total = 10, payment_date = '2019-01-03'
3
WHERE invoice_id = 1;
4

5
-- restore the data
6
UPDATE invoices
7
SET payment_total = DEFAULT, payment_date = NULL
8
WHERE invoice_id = 1;
9

10
-- update the 3rd id
11
UPDATE invoices
12
SET payment_total = invoice_total * 0.5, 
13
	payment_date = due_date
14
WHERE invoice_id = 3;