jenniferG Posted July 28, 2007 Share Posted July 28, 2007 Is there an esy way to copy a table schemna to a new table in mysql? We can certainly build a new tasble, but would like to copy schema. Jennifer Quote Link to comment https://forums.phpfreaks.com/topic/62194-table-copy/ Share on other sites More sharing options...
Illusion Posted July 30, 2007 Share Posted July 30, 2007 CREATE TABLE new_tbl LIKE old_tbl; Quote Link to comment https://forums.phpfreaks.com/topic/62194-table-copy/#findComment-311064 Share on other sites More sharing options...
fenway Posted July 31, 2007 Share Posted July 31, 2007 CREATE TABLE new_tbl LIKE old_tbl; Only from a certain version, though.... Quote Link to comment https://forums.phpfreaks.com/topic/62194-table-copy/#findComment-311983 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.