At 10:20 PM 8/22/2006, Chris wrote:
You can't store them in memory.
http://dev.mysql.com/doc/refman/5.1/en/temporary-table-problems.html
Despite what the doc says, I posted a working script here a couple of weeks
ago which creates temporary tables with engine=Memory. Either my
specification was being ignored in favor of some default--with no error
indication, or somebody forgot to document a new feature.
This has only been tried by me on Win XP.
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]