Hi, I'm using MySql 4.1.4 gamma and there are certain circumstances in
wich I need to create tables with random names from within querys.
And after using them I need to drop them; so I need a way to *remember* these table names so I can dispose them later.
Is that possible with MySql?
Mauricio:
I do not know of a way to do it without generating the name in the client langauge, or hacking MySQL source.
However, MySQL 4.1 does support a subselect. This may solve the need for the temporary table creation in your case.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]