List databases : Current Database « Database « SQL / MySQL

1. SQL / MySQL
2. Database
3. Current Database

List databases

 
/*
mysql> create database info;

mysql> Show databases;
+----------+
| Database |
+----------+
| info     |
| java2s   |
| mysql    |
| t        |
| test     |
| ttt      |
+----------+
6 rows in set (0.00 sec)

mysql> use info;
Database changed

*/  
  
create database info;

Show databases;

use info;




           
         
  

Related examples in the same category