At 12:24 AM +0200 10-14-2000, rino.mail@stripped wrote:
>I'd like to have information about the data in MySql:
>for example:
>How many Databases are in MySql? What is the name of Databases?
Run "SHOW DATABASES" for the names. Count the number of rows
to get the number of databases.
>The table's name?
SHOW TABLES FROM db_name
>
>How to create a Database by query?
CREATE DATABASE db_name
>Thank you in advance.
>Rino.
I suggest you have a look at the MySQL Reference Manual. There's
a link to it at the bottom of every message posted to this list.
The answers to all these questions are in chapter 7.
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/documentation/manual.php" before
>posting. To request this thread, e-mail mysql-thread53232@stripped
--
Paul DuBois, paul@stripped