SQL-complete-tutorial

1
-- update the multiple rows
2
UPDATE invoices
3
SET payment_total = invoice_total * 0.5, 
4
	payment_date = due_date
5
WHERE client_id = 3;
6

7
-- gives the same result
8
UPDATE invoices
9
SET payment_total = invoice_total * 0.5, 
10
	payment_date = due_date
11
WHERE client_id IN (3, 4);
12

13
-- Write a SQL statement to 
14
-- give any customers born before 1990
15
-- 50 extra points
16
USE sql_store;
17

18
UPDATE customers
19
SET points = points + 50
20
WHERE birth_date < '1990-01-01';
21