Re: [SOLVED?] Access Denied for CREATE TEMPORARY TABLE

2004-06-12 Thread Robert Paulsen
On Friday 11 June 2004 06:59 pm, Robert Paulsen wrote: > I must be missing something about "create temporary table". Here are two > sql commands. The first works the second fails: > > CREATE TABLE mytable (id int(10) NOT NULL auto_increment, data > varchar(255), PRIMARY KEY (id) ); CRE

Access Denied for CREATE TEMPORARY TABLE

2004-06-11 Thread Robert Paulsen
I must be missing something about "create temporary table". Here are two sql commands. The first works the second fails: CREATE TABLE mytable (id int(10) NOT NULL auto_increment, data varchar(255), PRIMARY KEY (id) ); CREATE TEMPORARY TABLE mytable2 (id int(10) NOT NULL auto_incre