If you are on 5.0.x you can use
SELECT column_Name
FROM INFORMATION_SCHEMA.columns;
INFORMATION_SCHEMA is a set of VIEWS that lets you access the database
structure. See
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
-Original Message-
From: Mike OK [mailto:[EMAIL
If you are using mysql 5.x you must be able to retrieve that you want using
information_schema database
Look:
mysql> select version();
+-+
| version() |
+-+
| 5.0.16-standard |
+-+
1 row in set (0.00 sec)
mysql> use information_schema;
Databas