Any row with a duplicate unique index value will replace the row that originally contained the value; for example: REPLACE INTO my_table( unique_index_column, other_column ) VALUES( 1, 'other value' ) ...

Historically, the dominant principle for data handling in MySQL has been, “Garbage in, garbage out.” However, as of MySQL 5.0.2, several SQL modes are available that enable you to reject bad ...