#insert into .. select
insert into testTable(n,n1) select 1,2 where not exist (select id from testTable where n = 1 limit 1)
#LEFT OUTER JOIN 即使有where条件,也全部显示左表的数据
#insert into .. select
insert into testTable(n,n1) select 1,2 where not exist (select id from testTable where n = 1 limit 1)
#LEFT OUTER JOIN 即使有where条件,也全部显示左表的数据