score:1

Accepted answer

I believe REPLACE will work for you (replace mysqldump option), since it behaves like this: If a row exists in the destination table that matches the row data in the REPLACE statement (based on PRIMARY KEY or UNIQUE KEY value(s)), that data in that row is deleted and replaced with the data in the source (dump file) row. If there is no such match, the source row is inserted into the destination table.


More questions

More questions with similar tag