Use the SHOW statement to find out what databases currently exist on the server: : SHOW « MySQL Utilities « MySQL Tutorial






  1. MySQL Tutorial
  2. MySQL Utilities
  3. SHOW
mysql>
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql>
mysql>

The mysql database describes user access privileges.

The test database is for users to try things out.









26.10.SHOW
26.10.1.SHOW COLUMNS and DESCRIBE can display information about the columns in individual INFORMATION_SCHEMA tables.
26.10.2.Use the SHOW statement to find out what databases currently exist on the server:
26.10.3.Display all table names
26.10.4.SHOW CREATE TABLE statement.
26.10.5.SHOW INDEX FROM tbl_name
26.10.6.To see the structure or schema of a database
26.10.7.Show a detailed listing of the columns of your database.