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 same amount of fields as the old database. Basically, I have something like Id Fname Mname Lname 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? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]