FWD: [PHP-DB] Copying or duplicating tables
-- Original Message -- From: Mark Lee <[EMAIL PROTECTED]> Date: Tue, 24 Sep 2002 13:04:12 -0600 In MySQL: I am looking for an easy way to create a table that will be identical to another table in the same database (except the table name, of course). I do not necessarily need the data duplicated, just the table structure. It seems like there should be some type of duplicate_table() or copy_table function, but have not found one. Any suggestions? Thanks, Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Copying or duplicating tables
Perfect. I thought there had to be some simple way to do that. Thanks a lot, Mark Rankin, Randy wrote: > create table duplicatetablename as select * from mytable > > -Original Message- > From: Mark Lee [mailto:[EMAIL PROTECTED] ] > Sent: Tuesday, September 24, 2002 2:04 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Copying or duplicating tables > > > In MySQL: > I am looking for an easy way to create a table that will be > identical to another table in the same database (except the table name, > of course). I do not necessarily need the data duplicated, just the > table structure. > It seems like there should be some type of duplicate_table() or > copy_table function, but have not found one. > > Any suggestions? > > Thanks, > > Mark > > > -- > PHP Database Mailing List ( http://www.php.net/ ) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Copying or duplicating tables
In MySQL: I am looking for an easy way to create a table that will be identical to another table in the same database (except the table name, of course). I do not necessarily need the data duplicated, just the table structure. It seems like there should be some type of duplicate_table() or copy_table function, but have not found one. Any suggestions? Thanks, Mark -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php