At 12:37 PM +0100 1/9/01, jed wrote:
>Hi @,
>and now my messages:
>
>mysql>
>mysql>
>mysql> create database test1;
>Query OK, 1 row affected (0.00 sec)
>
>mysql> create database test2;
>Query OK, 1 row affected (0.00 sec)
>
>mysql> use test1;
>Database changed
>mysql> create table test (txt varchar(20));
>Query OK, 0 rows affected (0.00 sec)
>
>mysql> insert into test values('Line1'),('Line2'),('Line3');
>Query OK, 3 rows affected (0.00 sec)
>Records: 3 Duplicates: 0 Warnings: 0
>
>mysql> use test2;
>Database changed
>mysql> create table tst2 select * from test1.test;
>ERROR 1064: You have an error in your SQL syntax near 'select * from
>test1.test' at line 1
>mysql>
>mysql>
>
>.............
>So, I suppose, that I have a version problem..
>
>I use at the time:
>kj@jed:~ > mysqladmin --version
>mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
>kj@jed:~ >
>
>Is it too old for this feature...?
Yes, you need MySQL 3.23.
--
Paul DuBois, paul@stripped
