Beefy Boxes and Bandwidth Generously Provided by pair Networks Bob
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Generating ALTER TABLE code for MySQL

by liz (Monsignor)
on Oct 21, 2006 at 09:28 UTC ( #579747=note: print w/ replies, xml ) Need Help??


in reply to Generating ALTER TABLE code for MySQL

Version 5.0 of MySQL has:

CREATE TABLE new_tbl LIKE orig_tbl;
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


Comment on Re: Generating ALTER TABLE code for MySQL
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://579747]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (7)
As of 2014-04-18 23:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (472 votes), past polls