Export Database and Use ON DUPLICATE KEY UPDATE

Escondido's profile image Escondido posted 4 weeks ago in General Permalink

I'm trying to figure out how to export a few tables and import them into another database using the SQL Export model. Goal being to update current records and add new ones when needed.

I found a thread from 9 years ago that looks promising, but I do not see the option to "insert new and update existing."

I only see insert and insert ignore.

Did that never get implemented?

ansgar's profile image ansgar posted 4 weeks ago Permalink

There is a "replace" mode, which should basically be the same as what you expect from an "insert on duplicate key" mode.

Please login to leave a reply, or register at first.