Is there a way to call "describe" on the temporary "table" that's generated
when you do a join or other type of query -- e.g. I can get a temporary
table by doing the following (useless) query:
mysql> select * from user,pet where user.id=pet.id;
+----+----------+--------------+---------+------+------------+-------+----+
| ID | username | name | owner | sex | birth | death | ID |
+----+----------+--------------+---------+------+------------+-------+----+
| 13 | 000diva | Snort | Bennett | m | 1986-12-08 | NULL | 13 |
| 14 | 01932220 | Fluttersnort | Bennett | f | 1987-05-23 | NULL | 14 |
| 15 | 080822 | Oliver2 | Tina | m | 1984-01-01 | NULL | 15 |
| 17 | 083048 | kermie | Bennett | m | 1984-01-01 | NULL | 17 |
| 18 | 0918 | snort | bennett | m | 1986-12-08 | NULL | 18 |
+----+----------+----------+-------------+------+--------------+----------+
but is there any way I can call "describe" on that table, to get the data
type of each column, and other information?
I'm interested in this because in the Web-based MySQL-table manipulation
tool that I wrote, the tables are displayed in a nice, readable format,
with labels at the top of each column giving their data type etc. I want a
way to submit JOINs and other queries, and have the results be formatted
just as nicely. If there's a way to call DESCRIBE on those results, I can
re-use most of my existing code.
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org
(425) 649 9024
---------------------------------------------------------------------
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