insert into select 的用法

分类: IT文章 • 2025-01-16 16:00:37

insert into tablename(属性1，属性2) select '值1','值2' from dual where exists (select 1 from tablename where 子句);