将所有to_date为9999-01-01的全部更新为NULL

update 语法结构:

update table_name
set column_name = value
where expression
update titles_test set to_date = NULL,
    from_date = '2001-01-01'
    where to_date = '9999-01-01';

学习mysql,可以看相关的总结博客:

mysql 学习 总结