Hello Mike,
On 27 Jun 05, mos wrote to mySQL list:
>> How can I prevent duplicate entries when I fill the data base with
>> "load data"? I tried ignore, but that has no effect.
m> Ignore/Replace will only work on Unique keys and I bet your key is
m> not unique. If you make it unique, then Ignore will keep the
m> existing value, or Replace will replace the existing row with the
m> new row.
You're good at betting :) The next question would of course be: how do
I create a unique key, but somebody else already asked that and got a
clear answer.
Thank you very much.
Regards,
Hans.
jdh dot beekhuizen at duinheks dot xs4all dot nl
--- GoldED+/LNX 1.1.5/040412
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
