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:woodbri@stripped]
> >
> > 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)
> > > >
