Re: 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:leemark@isu.edu ] Sent: Tuesday, September 24, 2002 2:04 PM To: php-db@lists.php.net 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