MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:August 10 2004 1:07pm
Subject:RE: using temp tables...
View as plain text  
CREATE TEMPORARY TABLE <table>
SELECT *
FROM <source_table>
... 
Query temp table
...
DROP TABLE <temp_table>

-----Original Message-----
From: bruce
To: mysql@stripped
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/mysql?unsub=1
Thread
using temp tables...bruce10 Aug
  • Re: using temp tables...Michael Stassen10 Aug
RE: using temp tables...Victor Pendleton10 Aug