CREATE TABLE new_table SELECT * FROM old_table LIMIT 0;
- Original Message -
From: Jason <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 15, 2002 10:44 AM
Subject: Is there a sql query to Copying tables
Is there an easy way to copy/use the structure (no
> Is there an easy way to copy/use the structure (not data) of a skeleton
table to a new table?
create table x select * from table y where 1=0;
-Lance
filter: sql
-
Before posting, please check:
http://www.mysql.com/manual
rom: Jason [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 11:45 AM
To: [EMAIL PROTECTED]
Subject: Is there a sql query to Copying tables
Is there an easy way to copy/use the structure (not data) of a skeleton
table to a new table?
Thanks in advance
PS how long has the sql,query requireme
Is there an easy way to copy/use the structure (not data) of a skeleton table to a new
table?
Thanks in advance
PS how long has the sql,query requirement been on this list?
-
Before posting, please check:
http://www.mysql
