UPDATE titles_test SET to_date = null,from_date = '2001-01-01'
WHERE to_date = '9999-01-01'

将满足条件的列内容进行修改

update + (表名称) + set + (列名称) = (修改后的新内容)

where + (条件判断列名称) = (满足的内容)