Perfect. I thought there had to be some simple way to do that.
Thanks a lot,
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?
> 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