INSERT INTO
org(EMPID,EMPNAME,MGRID)
select 9,“666”,7
FROM DUAL
WHERE not exists(SELECT * FROM org WHERE EMPNAME=“666”);
DUAL是mysql内置表
INSERT INTO
org(EMPID,EMPNAME,MGRID)
select 9,“666”,7
FROM DUAL
WHERE not exists(SELECT * FROM org WHERE EMPNAME=“666”);
DUAL是mysql内置表