Head First SQL: Hands-On SQL UPDATE/SET/CASE

Head First SQL: Hands-On SQL UPDATE/SET/CASE

瀏覽:872
日期:2026-04-23
Now try a CASE expression to update all of the categories at once (page 242), then try the exercise on page 245. UPDATE movie_table SET category = CASE WHEN drama = 'T' THEN 'drama' WHEN comedy = 'T' THEN 'comedy' WHEN action = 'T' THEN ......看更多