题解 | 显然GPT写的更完美
将所有to_date为9999-01-01的全部更新为NULL
https://www.nowcoder.com/practice/859f28f43496404886a77600ea68ef59
/* update titles_test
set to_date=NULL,from_date='2001-01-01'
where to_date='9999-01-01'; */ -- 自己写的
UPDATE titles_test
SET to_date = CASE
WHEN to_date = '9999-01-01' THEN NULL
ELSE to_date
END,
from_date = '2001-01-01'
WHERE to_date = '9999-01-01'; -- gpt写的
