create table x like y
Creates an exact copy of the table without the data, indexes are included.
----- Original Message -----
From: "J Trahair" <[EMAIL PROTECTED]>
To: "MySQL General" <mysql@lists.mysql.com>
Sent: Wednesday, May 23, 2007 3:58 PM
Subject: Replicating an existing table
Hi Everyone
Is there a way of replicating or cloning the structure of an existing table and giving it a different name? I have a table of items
on sale in the shops, I want to create a table of items not yet in the shops but due to be introduced very soon.
MySQL 5.0.37 Windows XP.
Thanks in advance.
Jonathan Trahair
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]