create table newtable select * from oldtable where 1<0;
This will solve your problem.
Best regards,
Fábio Ottolini
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 7:06 PM
Subject: How can I create one more table with
From: Subba Reddy M
Date: Fri, 26 Jan 2001 14:52:29 +0530
Hello MySQL guru,
Please advise me,
on creating new table with existing table structure.
I have tried, how MySQL documentation referred, but unable to get success.
create table newtable select * from oldtable;
This works on 3.23.x
Hello MySQL guru,
Please advise me,
on creating new table with existing table structure.
I have tried, how MySQL documentation referred, but unable to get success.
create table newtable select * from oldtable;