RE: type=heap problem...

2004-08-09 Thread Scott Hamm
: 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... &

RE: type=heap problem...

2004-08-09 Thread Paul DuBois
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

RE: type=heap problem...

2004-08-09 Thread Scott Hamm
lto:[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 tempo

Re: type=heap problem...

2004-08-09 Thread Terry Riley
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 tbl

type=heap problem...

2004-08-09 Thread Scott Hamm
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_

Heap problem

2002-02-12 Thread Tom Vatland
Hi! I made a head table like this: ## >create table SECURITIES ( SID varchar(16) not NULL, NAMEvarchar(255)not NULL, MARKET varchar(8) not NULL, TICKER

Heap problem

2002-02-11 Thread Tom Vatland
Hi! I made a head table like this: ## >create table SECURITIES ( SID varchar(16) not NULL, NAMEvarchar(255)not NULL, MARKET varchar(8) not NULL, TICKER