数据库表的创建和删除

#通过子查询创建表

create table DQAM3 as
select * from DQAM2 where related_alarm_cuid in (
'VENDOR_ALARM-8a49bf4322acd5a20122acd9a47e0585','VENDOR_ALARM-8a49bf4322acd5a20122acd9a52b05e4') and alarm_severity >= 4;

#删除表

drop table DQAM;

#清空表数据

truncate table zhjk;