Update multiple rows and columns at the same time

We want to increase the price of the tennis courts for both members and guests. Update the costs to be 6 for members, and 30 for guests.

facid	name	membercost	guestcost	initialoutlay	monthlymaintenance
2	Badminton Court	0	15.5	4000	50
3	Table Tennis	0	5	320	10
4	Massage Room 1	35	80	4000	3000
5	Massage Room 2	35	80	4000	3000
6	Squash Court	3.5	17.5	5000	80
7	Snooker Table	0	5	450	15
8	Pool Table	0	5	400	15
0	Tennis Court 1	6	30	10000	200
1	Tennis Court 2	6	30	8000	200

Loading database...

update cd.facilities
    set
        membercost = 6,
        guestcost = 30
    where facid in (0,1);

The SET clause accepts a comma separated list of values that you want to update.