Response from gordonb.vt4bk@burditt.org (Gordon Burditt):

>>Basically, I wish to store the result from a SELECT so that I can
>>use it or information based on it to insert into another table.
>>Is that possible with MySQL so I do not have to reinvent the wheel
>>in the application server itself?
>
> You can do it with CREATE [TEMPORARY] TABLE used with a SELECT
> statement to populate it.
>
> CREATE TEMPORARY TABLE frootlist (frootid int not null
> auto_increment primary key, frootname varchar(30)) SELECT
> null as frootid, distinct fruit from fruitbasket_contents;
>
> (Checked for syntax running it on MySQL 5.0.45, not checked for
> results.)

Marvelous! I had not even thought in this direction at all. Thanks!

>>This pertains to my original table example of fruits being
>>associated with other fruits.
>>
>>Message-ID: <WvCdnQOuIt7YO2vbnZ2dnUVZ_q_inZ2d@comcast.com>
>>
>>I thought the query cache was the place to look, but evidently
>>not.
>
> As I understand it, the query cache is not particularly visible
> except for performance and commands that configure it.

Ah, OK. And there does not seem to be any functions that directly
use data stored in the cache. I was thinking since the query cache
utilizes temporary tables that it might be possible to extract said
results.

Ah well, creating my own temporary table is basically the same thing.

Thanks again for pointing that out!

--
-Lost
Remove the extra words to reply by e-mail. Don't e-mail me. I am
kidding. No I am not.