Is there a way to make an exact copy of a table and give the copy a new name?
Thanks,
John
From the doc :
As of MySQL 3.23, you can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement:
CREATE TABLE new_tbl SELECT * FROM orig_tbl;
have a look here : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
-- Philippe Poelvoorde COS Trading Ltd.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
