Re: INSERT statements with columns that don't exist

2005-06-20 Thread Davy Durham
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

INSERT statements with columns that don't exist

2005-06-17 Thread Davy Durham
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.