here is an interesting problem. I have data in a comma delimited text file. It is easy to load the values directly into my table using mySQL "load data infile" command.
Now comes the tough cookie. I want to load multiple data into multiple tables and so when there is a primary key on one of the fields, i must replace the occurence of that value in all subsequent records. Sounds confusing right ? Well its all a part of data migration while keeping relationships intact. Anyone help pleeez