关于exits的用法
IF EXISTS (
)THEN
//DO YOUR JOB
END IF;
举例:
if exists (select * from test) then
insert into ttt(id) values (generate_unique());
end if;
IF EXISTS (
)THEN
//DO YOUR JOB
END IF;
举例:
if exists (select * from test) then
insert into ttt(id) values (generate_unique());
end if;