On 9 Jun 2003 at 13:16, Campbell D. McCausland wrote: > Thank you for your responses. Unfortunately, the sql > I'm loading is output from another tool, so I don't > get to vote on the format of the insert statements. > > If it's not possible to just turn the check off, then I > guess I'll have to consider writing a perl script or > something to add the column specifiers.
Another way would be to make a table with the old structure (without the new columns) and import into it, then do a SELECT ... INSERT from it into the real table, specifying the columns. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]