SHOW TABLES lists tables in a db
DESCRIBE tablename (= SHOW CREATE TABLE tablename) outputs column info,
but your application will have to parse it.
EXPLAIN is for query optimisation analysis, not table column listings.
The manual's pretty clear on these topics.
PB
-
Dave Merrill wrote:
Hi, m
[Sending this to this list, just for general reference, since I didn't
notice that Reply on this list goes to the poster, not the list. No other
list I'm on works that way, so I plead Failure To Open Eyes.]
Dave Merrill
> "Dave Merrill" wrote on 01/12/2005 04:56:34 PM:
>
> > Thanks Shawn, looks l
In addition to Shawn's suggestions, the other approach you could take would
be to write Java programs that make use of the DataBaseMetaData and
ResultSetMetaData interfaces. I've used this approach with success, although
not to any great extent yet.
Of course, if you don't know Java or don't appro
May I introduce you to the family of SHOW commands?
SHOW DATABASES - lists all databases on a server
SHOW TABLES - lists all tables within your current database
SHOW CREATE TABLE x - returns a table containing a SQL statement you
could use to recreate the table x if you needed to (includi
