--创建临时表判断表是否存在
drop TABLE IF EXISTS tbt;
CREATE TEMP TABLE IF NOT EXISTS tbt
(
id int,
a varchar(55),
b varchar(55)
);
delete from tbt;
insert into tbt1(id,a,b)
values(1,'a1','b1');
insert into tbt1(id,a,b)
values(2,'a2','b2');
--创建临时表判断表是否存在
drop TABLE IF EXISTS tbt;
CREATE TEMP TABLE IF NOT EXISTS tbt
(
id int,
a varchar(55),
b varchar(55)
);
delete from tbt;
insert into tbt1(id,a,b)
values(1,'a1','b1');
insert into tbt1(id,a,b)
values(2,'a2','b2');