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' ) ...