UPDATE titles_test
SET to_date = NULL,
from_date = '2001-01-01'
WHERE
to_date = '9999-01-01'
牛客SQL练习-43-将所有to_date为9999-01-01的全部更新为NULL,且 from_date更新为2001-01-01
最新推荐文章于 2021-08-26 09:58:50 发布
UPDATE titles_test
SET to_date = NULL,
from_date = '2001-01-01'
WHERE
to_date = '9999-01-01'