List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 4 2000 5:16am
Subject:Re: Temporary tables
View as plain text  
At 3:21 AM +0100 2000-02-04, Magnus Erixzon wrote:
>Hello,
>
>According to the manual (version 3.22.27) I can create temporary tables.
>But this happens, when I try it;
>
>mysql> create temporary table temp (a int);
>ERROR 1064: You have an error in your SQL syntax near 'temporary 
>table temp (a int)' at line 1
>
>Also, as said in the manual, a select should be possible at the same time as
>create;
>
>mysql> create table temp (a int(10)) type=heap select id from app;
>ERROR 1064: You have an error in your SQL syntax near 'select id 
>from app' at line 1
>
>What is wrong here?
>
>Im using Linux, mysql version 3.2.27


Check the change notes, you'll notice that these features were not
added until MySQL 3.23.

-- 
Paul DuBois, paul@stripped
Thread
Temporary tablesMagnus Erixzon4 Feb
  • Re: Temporary tablesPaul DuBois4 Feb