Re: How can I create one more table with existing table structure

2001-01-29 Thread Fábio Ottolini
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

How can I create one more table with existing table structure

2001-01-29 Thread daveclark
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

How can I create one more table with existing table structure

2001-01-26 Thread Subba Reddy M
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;