MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:March 26 2000 11:02am
Subject:Re: type=heap supported in 3.22 ?
View as plain text  
Ing. Nikolai Vladychevski writes:
 > Hello,
 > why this doesnt work, i copied the syntax from the manual?
 > mysql> select * from desckey;
 > +-----------+--------------+
 > | keywordID | classifiedID |
 > +-----------+--------------+
 > |         1 |            1 |
 > |         2 |            1 |
 > |         3 |            1 |
 > |         4 |            1 |
 > |         5 |            1 |
 > |         6 |            1 |
 > |         7 |            1 |
 > |         8 |            1 |
 > |         9 |            1 |
 > |        10 |            1 |
 > |        11 |            1 |
 > |        12 |            1 |
 > |        13 |            1 |
 > |        14 |            1 |
 > +-----------+--------------+
 > 14 rows in set (0.05 sec)
 > 
 > mysql> create table xxx (classifiedID int) type=heap select classifiedID
 > from desckey;
 > ERROR 1064: You have an error in your SQL syntax near 'select
 > classifiedID from desckey' at line 1
 > mysql> 
 > 
 > 
 > I use this builds on linux, does it has temporary tables support?
 > MySQL-3.22.32-1
 > MySQL-client-3.22.32-1
 > MySQL-devel-3.22.32-1
 > 


Hi!

HEAP tables and CREATE from SELECT were introduced in 3.23.0.

Regards,

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped     |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
type=heap supported in 3.22 ?Ing. Nikolai Vladychevski26 Mar
  • Re: type=heap supported in 3.22 ?Benjamin Pflugmann26 Mar
  • Re: type=heap supported in 3.22 ?sinisa26 Mar