INSERT INTO g80_shyj ( SHYJ_ID, SQ_ID ) #插入的字段名
SELECT 'aa11aa', 77 #插入对应字段名的值
FROM
DUAL
WHERE NOT EXISTS
( SELECT SHYJ_ID FROM g80_shyj WHERE SHYJ_ID = 'aa11aa');
#如果满足该(SHYJ_ID = 'aa11aa')就不执行该条记录的插入
INSERT INTO g80_shyj ( SHYJ_ID, SQ_ID ) #插入的字段名
SELECT 'aa11aa', 77 #插入对应字段名的值
FROM
DUAL
WHERE NOT EXISTS
( SELECT SHYJ_ID FROM g80_shyj WHERE SHYJ_ID = 'aa11aa');
#如果满足该(SHYJ_ID = 'aa11aa')就不执行该条记录的插入