语法:INSERT INTO TABLE名 SELECT 具体值 WHERE NOT EXIST(查询语句)
例如:
INSERT INTO `alarm_input_type`
SELECT '10100', '穿越警戒面', '2011-12-05 19:30:02', null, null, null, null FROM DUAL
WHERE not exists (select * from alarm_input_type where alarm_input_type.input_type = '10100');