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

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

瀏覽:549
日期:2025-04-26
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 ......看更多