At 13:40 -0400 8/9/04, Scott Hamm wrote:
Hmm... while researching for table=heap; I found the following, and tried to
implement to no avail... So I tried that example and yet failed...
http://builder.com.com/5100-6388-1058872.html
Subtitled "Flipping the switch"
You might want to read the section in the MySQL manual that discusses
MEMORY (HEAP) tables:
http://dev.mysql.com/doc/mysql/en/HEAP.html
This item is relevent to your situation:
MEMORY doesn't support AUTO_INCREMENT columns before MySQL 4.1.0.
So I would guess that you're running MySQL 3.23.x or 4.0.x.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 1:36 PM
To: [EMAIL PROTECTED]
Subject: Re: type=heap problem...
I think the error is self-explanatory - you can't use auto_increment in a
heap table (but you can have an index)
Terry
----- Original Message -----
I couldn't get temporary table to load into memory using type=heap,
here's
the sample error as following:
mysql> create table tblheap (
-> id int not null auto_increment,
-> primary key (id),
-> value_a tinyint )
-> type=heap;
> ERROR 1164: The used table type doesn't support AUTO_INCREMENT columns
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
