Thanks all. I already upgraded mysql to beta version of more than 4.1.x (rookie here trying to figure out a way to issue command to show the current version in shell prompt....)
finally got type=heap to work. Thanks all. -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 2:35 PM To: Scott Hamm; [EMAIL PROTECTED] Subject: RE: type=heap problem... 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]