CREATE TEMPORARY TABLE <table> SELECT * FROM <source_table> ... Query temp table ... DROP TABLE <temp_table>
-----Original Message----- From: bruce To: [EMAIL PROTECTED] Sent: 8/10/04 12:45 AM Subject: using temp tables... hi... in trying to get a better understanding of temp tables. is there a way to perform a select, to write the results to a temp table, and then use the temp table to perform another operation on the information within the temp table... ie... select * from foo write the results of the select to a temp table perform an operation on the information stored within the temp table i'm curious as to how it can be done within the mysql env. searching through google/mysql didn't spell this out to me... thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
