Don't ask to ask, just ask | |
PerlMonks |
Re: Generating ALTER TABLE code for MySQLby liz (Monsignor) |
on Oct 21, 2006 at 09:28 UTC ( [id://579747]=note: print w/replies, xml ) | Need Help?? |
Version 5.0 of MySQL has:
Use LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table (see http://dev.mysql.com/doc/refman/5.0/en/create-table.html ). Maybe something like that, in combination with a SELECT from the table into the new table, and some table renames, would also be an option? Liz
In Section
Seekers of Perl Wisdom
|
|