At 3:21 AM +0100 2000-02-04, Magnus Erixzon wrote:
>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
>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
|• Temporary tables||Magnus Erixzon||4 Feb|
| • Re: Temporary tables||Paul DuBois||4 Feb|