On Wed, Jan 15, 2003 at 11:55:44PM +, [EMAIL PROTECTED] wrote:
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
If you're in Java you can call getMetaData on the ResultSet, and then call methods on
that (ResultSetMetaData) to determine number of columns, and type of each column.
This avoids the steps of creating/deleting a temp table.
What language are you using?
From: Will Standley [EMAIL
Hello.
Please start a new thread instead of replying to an existing one. Or
else, your message will be sorted with the original thread for people
with decent mail readers.
On Wed 2003-01-15 at 14:42:05 -0500, [EMAIL PROTECTED] wrote:
How do you query the table that is the results of a query?
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,
