简介
修改数据
update titles_test set
emp_no = replace(emp_no, 10001, 10005) where id = 5;
update titles_test set
to_date = NULL,
from_date ='2001-01-01'
where to_date = '9999-01-01';
修改数据
update titles_test set
emp_no = replace(emp_no, 10001, 10005) where id = 5;
update titles_test set
to_date = NULL,
from_date ='2001-01-01'
where to_date = '9999-01-01';