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]
