Insert Ignore - Mysql Query
Jun 3rd, 2009 by sherlock Hit :: 6118
The new value is not inserted if there is a duplicate key.
syntax ::
INSERT ignore into T values(a, b, c)
INSERT ignore into T(a, b, c) SELECT a, b, c FROM F
*TABLE must have a primary key.