创建表的备份和删除

2019独角兽企业重金招聘Python工程师标准>>>

create table zzz_bak as select * from zzz where 删除条件;

 

delete from zzz where 删除条件;

create table stat_call_bak_20140408 as select *from stat_call a where a.call_type=1 and a.status=2 and to_char(a.begin_time,'yyyy-mm-dd')='2014-01-01'

delete from stat_call a where a.call_type=1 and a.status=2 and to_char(a.begin_time,'yyyy-mm-dd')='2014-01-01'

转载于:https://my.oschina.net/liuruibin/blog/816100