一、打开指定的数据库
USE db_name;
mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| learndb1 |
| learndb2 |
| mysql |
| osms |
| performance_schema |
| sakila |
| test |
| world |
+--------------------+
9 rows in set (0.08 sec)
mysql> USE learndb1;
Database changed
+--------------------+
| Database |
+--------------------+
| information_schema |
| learndb1 |
| learndb2 |
| mysql |
| osms |
| performance_schema |
| sakila |
| test |
| world |
+--------------------+
9 rows in set (0.08 sec)
mysql> USE learndb1;
Database changed
二、得到当前已打开的数据库
SELECT {DATABASE()|SCHEMA()};
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| learndb1 |
+------------+
1 row in set (0.00 sec)
+------------+
| DATABASE() |
+------------+
| learndb1 |
+------------+
1 row in set (0.00 sec)