Temporary tables work pretty much like regular tables, except they don't last.
CREATE TEMPORARY TABLE bar SELECT * FROM foo WHERE ...
UPDATE bar SET ...
SELECT * FROM foo JOIN bar on foo.id = bar.id WHERE ...
Michael
bruce wrote:
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]
