Yeah, just making it an index doesn't guarantee uniqueness. I think what I'd do is import to a temp table, remove the dupes, and then insert them into your final table. > -----Original Message----- > From: thelist-bounces at lists.evolt.org > [mailto:thelist-bounces at lists.evolt.org]On Behalf Of r937 > Sent: Tuesday, February 27, 2007 10:12 AM > To: thelist at lists.evolt.org > Subject: [thelist] [MySQL] - REPLACE or INSERT IGNORE > > > > Anyone care to tell me what I'm doing wrong? > > probably forgot to declare a primary or unique key > > > rudy > http://r937.com/ > > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! >