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" -----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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
