List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:January 9 2001 2:31pm
Subject:Re: SQL...
View as plain text  
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
Thread
Danger! Will Robinson - NewbieSteve Mills7 Jan
  • Re: Danger! Will Robinson - NewbieJohn Dean7 Jan
    • SQL...jed7 Jan
RE: SQL...Rasmus Nyström7 Jan
  • Re: SQL...Jr. Frank M. Betz8 Jan
    • Re: SQL...Paul DuBois8 Jan
      • Re: SQL...Nick Tentomas8 Jan
        • Re: SQL...Paul DuBois8 Jan
    • RE: SQL...Luc Van der Veken9 Jan
      • Re: SQL...jed9 Jan
        • Re: SQL...Paul DuBois9 Jan
      • Re: SQL...Stephen Woodbridge9 Jan
        • RE: SQL...Luc Van der Veken10 Jan
          • Re: SQL...jed10 Jan
      • Re: SQL...jed9 Jan
      • RE: SQL...Paul DuBois9 Jan
      • Re: SQL...jed9 Jan
  • Re: SQL...jed8 Jan
  • Re: SQL...jed8 Jan
    • Re: SQL...Tim Endres8 Jan
      • Re: SQL...Paul DuBois9 Jan
    • Re: SQL...Paul DuBois9 Jan