Yurttas/PL/DBL/mysql-f-2010/01/SPJ/q08.sql

 1/*
 2REM
 3REM q08.sql
 4REM
 5REM Change the color of part 'P02' to 'Yellow',
 6REM increase its weight by 5, and
 7REM set its city to unknown('NULL').
 8REM
 9*/
10
11\. set-db.sql
12
13UPDATE Parts
14SET color='Yellow',
15    weight=weight+5,
16    city='NULL'
17WHERE pn = 'P02';