INSERT INTO table_name (id, name, age)
SELECT * FROM (SELECT '1000', 'ndh', 32) AS tmp
WHERE NOT EXISTS (
SELECT 1 FROM table_name WHERE id = '1000'
)
注意: tmp里的字段不能重复,如果重复会报错,需要用as来指定别名以免重复
INSERT INTO table_name (id, name, age)
SELECT * FROM (SELECT '1000', 'ndh', 32) AS tmp
WHERE NOT EXISTS (
SELECT 1 FROM table_name WHERE id = '1000'
)
注意: tmp里的字段不能重复,如果重复会报错,需要用as来指定别名以免重复