mysql 防止重复插入数据:
一:利用on duplicate key UPDATE语句:
INSERT INTO mac_netbar VALUES('ff','001001001000000')
on duplicate key UPDATE mac_addr = 'ff' ,netbar_id ='001001001000001'
更新存在的主键列记录,并且防止了重复数据
二 利用where not exists语句:
insert into TABLE(FIELD0,FIELD1...) select VALUE0,VALUE1 ,... from dual where not exists(select * from TABLE where FIELDN=VALUEN)
举例:
INSERT INTO mac_netbar
select 'ffff','001001001000000' from dual
where not exists(select * from mac_netbar where mac_addr='ffff')