INSERT INTO 表A SELECT 值, 值, 值, …… FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM 表A WHERE 字段A = 值) 这条sql语句适用于oracle和mysql。 MSSQL:去掉 "FROM DUAL";