22 messages in com.mysql.lists.win32Re: SQL...
FromSent OnAttachments
Steve Mills06 Jan 2001 15:52 
John Dean07 Jan 2001 01:33 
jed07 Jan 2001 02:20 
"Nyström, Rasmus"07 Jan 2001 08:42 
Frank M. Betz, Jr.07 Jan 2001 21:10 
jed07 Jan 2001 23:50 
Paul DuBois08 Jan 2001 07:45 
Nick Tentomas08 Jan 2001 08:19 
jed08 Jan 2001 09:47 
Tim Endres08 Jan 2001 11:30 
Paul DuBois08 Jan 2001 13:50 
Paul DuBois08 Jan 2001 16:38 
Paul DuBois08 Jan 2001 16:39 
Luc Van der Veken09 Jan 2001 00:56 
jed09 Jan 2001 03:37 
Stephen Woodbridge09 Jan 2001 06:16 
jed09 Jan 2001 06:28 
Paul DuBois09 Jan 2001 06:29 
Paul DuBois09 Jan 2001 06:30 
jed09 Jan 2001 07:00 
Luc Van der Veken09 Jan 2001 23:47 
jed09 Jan 2001 23:52 
Subject:Re: SQL...
From:jed (webm@wol.de)
Date:01/09/2001 11:52:52 PM
List:com.mysql.lists.win32

Hi @ll,

yes I know it. I believe you too, that it works.... :-)))))

My version of Mysql was too old, so I couldn't test it....

thanx

regards jed

Luc Van der Veken wrote:

From: Stephen Woodbridge [mailto:wood@mediaone.net]

Is this a typo in the email or a typo in your commands:

mysql> create table tst2 select * from test1.test;

^^^^ test2

Neither, I cut & pasted everything straight from the MySQL window (I omitted the E deliberately to make the difference between table tst2 and database test2 more clear).

But you do need at least version 3.23.0 for the "create table ... select ..." syntax. As you can see in the query that followed it, it works:

mysql> select * from test2.tst2; +-------+ | txt | +-------+ | Line1 | | Line2 | | Line3 | +-------+ 3 rows in set (0.00 sec)