Insert Ignore - Mysql Query
Jun 3rd, 2009 by sherlock Hit :: 415
The row won’t actually be inserted if it results in a duplicate key.
Syntac ::
Insert ignore into T values(a, b, c)
Insert ignore into T(a, b, c) SELECT a, b, c FROM F
NB :: table must have a primary key.