How to get the lists of DB from MySQL system tables?

2002-10-09 Thread Jojo Morales 

Hi Guys,

I'm using MySQL for Windoze (latest version of Server  ODBC).

Is it possible to get the lists of DB in the Windows using the system
tables of MySQL?
or any workaround you can suggest.

Many thanks in advance.

Regards,
Jojo


__
Do You Yahoo!?
Great flight deals, travel info and prizes!
http://sg.travel.yahoo.com

-
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

re: How to get the lists of DB from MySQL system tables?

2002-10-09 Thread Victoria Reznichenko 

Jojo,
Wednesday, October 09, 2002, 12:00:07 PM, you wrote:

JM I'm using MySQL for Windoze (latest version of Server  ODBC).

JM Is it possible to get the lists of DB in the Windows using the system
JM tables of MySQL?

If you what to get a list of databases just use SHOW DATABASES
command:
http://www.mysql.com/doc/en/SHOW.html

But how MySQL system tables is related to list of databases? ;)


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-
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