On 24 Sep, 02:15, "-Lost" <maventheextrawo...@techie.com> wrote:
> I can easily visualize this with the assistance of PHP, Perl, or
> Python. Yet I am not exactly sure what I am looking for in the MySQL
> manual.
>
> 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?
>
> 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.
> And I cannot seem to locate information for "result" or "result set"
> very effectively. I am looking in the CHM version of the latest 5.1
> manual if that makes any difference.
>
> Thanks.
>
> --
> -Lost
> Remove the extra words to reply by e-mail. Don't e-mail me. I am
> kidding. No I am not.

INSERT ... SELECT
http://dev.mysql.com/doc/refman/5.0/...rt-select.html