--创建备份表备份删除数据
create table oms_ss_gx_work_plan_20160427 as select * from oms_ss_gx_work_plan t where t.work_plan_type in('1','0');
--删除数据 年度计划和月度计划
delete from oms_ss_gx_work_plan t where t.work_plan_type in('1','0');
create table oms_ss_gx_work_plan_20160427 as select * from oms_ss_gx_work_plan t where t.work_plan_type in('1','0');
--删除数据 年度计划和月度计划
delete from oms_ss_gx_work_plan t where t.work_plan_type in('1','0');