Re: temp table cannot be created?

Hello. See: http://dev.mysql.com/doc/mysql/en/temporary-table-problems.html http://bugs.mysql.com/bug.php?id=10105 Jason Pyeron [EMAIL PROTECTED] wrote: any ideas on this? google has not helped. can temp tables be innodb? can they have fk? mysql mysql

Re: temp table cannot be created?

Thanks. On Thu, 21 Jul 2005, Gleb Paharenko wrote: See: http://dev.mysql.com/doc/mysql/en/temporary-table-problems.html this page I have read before, but no mention of this problem. http://bugs.mysql.com/bug.php?id=10105 now this was right on target. it lead me to use the

temp table cannot be created?

any ideas on this? google has not helped. can temp tables be innodb? can they have fk? mysql mysql create temporary table bvolsetparents - ( - volset int not null, - ancestor int not null, - primary key (volset,ancestor), - foreign key (volset) REFERENCES bvolset(id),