Re: Load data infile or import

2004-03-31 Thread Scott Haneda
on 03/31/2004 01:02 AM, Harald Fuchs at [EMAIL PROTECTED] wrote: >> Where the new data to import is missing the Mname and id, so I will create >> full complete insert statements, but how to load that in? > > Depending on your table structure, the following quotation from The > F*** Manual might a

Load data infile or import

2004-03-30 Thread Scott Haneda
I have a few hundred thousand records to import to a database, there are already a few hundred thousand records in the database now. What is the best way to append these new records to the old database? I can not seem to use load data infile unless I want to preformat the data to have the exact s