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   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

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 10;

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