网址:http://www.jb51.net/article/49156.htm
利用not exists语句
insert into deviceentry (customerId,allNumber) select 'c','d' where not exists (select * from deviceentry);
网址:http://www.jb51.net/article/49156.htm
利用not exists语句
insert into deviceentry (customerId,allNumber) select 'c','d' where not exists (select * from deviceentry);