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 PROTECTED]> > Subject: --- How to query results of a query? > Date: 16/01/2003 6:42:05 > To: [EMAIL PROTECTED] > > 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 > > This message was sent through MyMail http://www.mymail.com.au --------------------------------------------------------------------- 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
