This is more of a note to myself, but I use it to dump databases where there are additional fields in the new table. When you're upgrading a database you can either add the new fields to the old table or move the data from an older table to a newer one.

I usually like to add the new fields, but when it's a major upgrade I just start with a fresh, current table. That's where this code comes in handy. You use this to dump the data from the older table. That way it can be inserted into the newer table without any hassles over an incompatible number of fields.

mysqldump --complete-insert database table > table.sql