Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an sql command?
I hope so, I need to know what the SQL command is so I can pass it to
perl DBI.
M.
--
Mark Worsdall
https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ
show tables from database;
- Original Message -
From: Mark Worsdall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 2:42 PM
Subject: How to read table names within database?
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any
The command show tables;
will give you what you want.
See: http://www.mysql.com/doc/en/SHOW.html
Gurhan
On Fri, 2002-09-06 at 02:42, Mark Worsdall wrote:
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an
On Fri, 6 Sep 2002, Mark Worsdall wrote:
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an sql command?
I hope so, I need to know what the SQL command is so I can pass it to
perl DBI.
M.
Try show
Mark,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an sql command?
Parse the contents of SHOW DATABASES and then use the ouput of that to
SHOW TABLES...
mysql, query.
DSL