please look at page 194 of the reference manual...

>(and if so how do you ask MySQL to create a temp table from the 
> results of aquery?)

here's an example:

mysql> create temporary table tmp (name varchar(20), owner varchar(20, species 
varchar(10));

mysql> insert into tmp select name, owner, species from pet where species='Dog';

These 2 statements put the results of the "select name, owner, species from pet 
where..." query in the temporary table tmp.

thanks 
Nasser.



==============================================================
How do you query the table that is the results of a query?

Must you ask MySQL to...
....create a temporary table form the results of the first query
....then query that temporary table
....then delete the temp table when you are done?

(and if so how do you ask MySQL to create a temp table from the results of a
query?)

Is there a better and faster way to do this with minimum burden on the web
server with the db on it?

Thanks for any help.

Will





---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to