首页 > 代码库 > update mantis_bug_table

update mantis_bug_table

update mantis_bug_table set mantis_bug_table.original_due_date=mantis_bug_table.due_date 
where mantis_bug_table.original_due_date in (0,1)
and mantis_bug_table.due_date not in (0,1);

 

update mantis_bug_table