List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 14 2000 8:34pm
Subject:Re: How get MetaData or data about data in MySql?
View as plain text  
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
Thread
How get MetaData or data about data in MySql?rino.mail@libero.it14 Oct
Re: How get MetaData or data about data in MySql?Paul DuBois14 Oct