Ah, Thanks for the info.. Unfortunately, I already started things out
using mysqldump -c so it just creates complete insert statements. I
would be a little difficult to change things now. I will either have to
consider changing the way the dump files are created and then use LOAD
DATA, or just
Davy Durham <[EMAIL PROTECTED]> wrote on 06/17/2005 12:41:24 PM:
> Hi,
> I was wondering if there's a way to make mysql not care about (or
> ignore) columns in an insert statement that don't exist in the table.
> For example, I have a dump from a table with 10 columns, but the new
> table has one
Hi,
I was wondering if there's a way to make mysql not care about (or
ignore) columns in an insert statement that don't exist in the table.
For example, I have a dump from a table with 10 columns, but the new
table has one of the columns dropped.. well restoring from the dump
causes errors.