Re: [PHP3] [MySQL] CREATE TEMPORARY TABLE doesn't work !

In article <000501bfd230$a42f7520$01000001@piektware>, repsons@mail.lv (=?iso-8859-4?Q?J=C0nis_Repsons?=) wrote: > This expression returns error "MySQL said: You have an error in your SQL > syntax near 'TEMPORARY TABLE temp1 (a int not null auto_increment, primary > key (a), name varc' at line 1" > > CREATE TEMPORARY TABLE temp1 (a int not null auto_increment, primary key > (a), name varchar(32)) > > - without this "TEMPORARY" - it witks fine ! Can you create a temporary table in the MySQL command-line monitor? I suspect you're using the wrong SQL or an older version of MySQL that doesn't support temporary tables. -- Richard Lynch | If this was worth $$$ to you, buy a CD US Customer Support Director | from one of the artists listed here: Zend Technologies USA | http://www.L-I-E.com/artists.htm http://www.zend.com | (this has nothing to do with Zend, duh!)