Re: Preventing duplicates with "load data"

2005-06-28 Thread lists . mysql-users
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 Ign

Re: Preventing duplicates with "load data"

2005-06-27 Thread mos
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

Preventing duplicates with "load data"

2005-06-27 Thread lists . mysql-users
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. jdh dot beekhuizen at duinheks dot xs4all dot nl --- GoldED+/LNX 1.1.5/04041