At 08:11 AM 6/27/2005, you wrote:
Hello,
How can I prevent duplicate entries when I fill the data base with
"load data"? I tried ignore, but that has no effect. Probably I'm
something very elementary, but I'm still learning...
Regards,
Hans.
Hans,
Ignore/Replace will only work on Unique keys and I bet your key is
not unique. If you make it unique, then Ignore will keep the existing
value, or Replace will replace the existing row with the new row.
Mike
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
