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
