Re: Where does the time go?

[Mark Modrall]

I was just kind of assuming that LOAD DATA INFILE wouldn't work well with tables normalized over an auto-increment column. Aside from the question of how you get the auto-increment value to serve as your foreign key in the child tables, what happens when you re-create a unique index after a LOAD DATA? I mean, if LOAD DATA does load duplicates, what happens when you re-create the UNIQUE index? wouldn't it just break, saying it was in violation?

Thanks
_mark