mysql sub-select work around?

[Mike Starke]

/_> /_create temporary table tmp_idt
/_> /_SELECT (idt.unit * idt.price) AS Sub_Total
/_> /_FROM idt WHERE idt.myid = "1";
/_> /_
/_MySQL allows you to create a temp table and populate with the results of a select in one shot.  That's what this 
/_statement does.  If the 'create temporary table' statement is immediately followed by a select statement, the results 
/_of the select statement are populated into the the table using the columns names & data types returned from the select 
/_statement.
/_

I had no idea it worked that way (populated if immediately followed by a select..). 
I looked through the documentation on/at MySQL and could not find this info
documented anywhere.

/_As an aside, if the column idt.myid is an int datatype you don't need to quote it.  If it's an integer and you quote 
/_it, MySQL must do an implicit data type conversion, which may slow things down a bit.  If the myid column is a varchar 
/_data type then you must quote it.
/_

I didn't know that either...........many thanks for the tips today.

I suspect everything you pointed out above is MySQL specific isn't it. (?)
I have always made every effort to construct statements plain enough
as to be ported amongst rdbm's. 

v/r
-Mike