UPDATE + INSERT option in Export

Hi, I want to know if is it possible to make update and insert data into a 2nd database in EXPORT MODE?
For example, I have 2 similar databases.I want to export data in another database. If data already, exists, system must make update. If it does not exist, it must be inserted.
Help me please !

Using the "REPLACE" mode should roughly do what you want to do.

A replace would delete that row and insert it again.
This could delete referencing data in other tables (foreign key 'ON DELETE CASCADE').

A better choice would be an option like 'ON DUPLICATE KEY UPDATE'!

Ok, sounds reasonable. That will require a new option in the data dropdown - something like "Insert new and update existing"

We need an Export SQL Update Option too.

This is very usefull if you selected just a few columns and you want to export and update your existing production database.

On Replace all data is erased, the columns selected are refilled, but all not selected are filled with default values. (I ran into once :-P but my fault)

Thx