Hello,
I use tables with one primary key (which is the only unique key). I'd like
to export data from such a table to a file, and then import it on another
machine.
If a duplicate unique key is found when importing with LOAD DATA INFILE,
MySQL gives me the choice of whether to
1. stop execution with an error
2. not import rows with duplicate unique keys (using IGNORE)
What I'd like to do is to alter the unique key (either the imported or the
existing one) to a value that does not already exist, and then import the
row.
Do I have to fall back on a bunch of INSERT statements to accomplish this,
or do you see a way to get there with LOAD DATA INFILE?
Thank you very much!
Gerhard Prilmeier
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
