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 existing table structure
> 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 check doc for version.
>
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
