题解 | #将所有to_date为9999-01-01的全部更新为NULL#
update titles_test set to_date = null , from_date = '2001-01-01' where to_date = '9999-01-01'
考察update 语句
update table set () values ()
update table set colum = value,colum = value
update titles_test set to_date = null , from_date = '2001-01-01' where to_date = '9999-01-01'
考察update 语句
update table set () values ()
update table set colum = value,colum = value
相关推荐