1. mysql> SHOW databases;
2. mysql> USE MessageNotification;
3. mysql> SHOW TABLES FROM MessageNotification;
hth
At 10:58 AM +0200 6/22/01, Tiwonge Nathan Kawonga wrote:
>How can I query the database to know that a specific table exists in a
>given database.
>
>for example my database is MessageNotification and I want to know if
>Message_data table exists in this database. I am using Mysql++ to query
>the database.
>
>Thanks in advanced
>
>Tiwonge
>
>---------------------------------------------------------------------
>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
---------------------------------------------------------------------
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
