1.查看当前MySQL拥有的数据库
show databases;
首先要登录上数据库(mysql -u root -p123456)。
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_base |
| db_cache_web |
| db_tars |
| db_tars_web |
| db_user_system |
| mysql |
| performance_schema |
| sys |
| tars_property |
| tars_stat |
+--------------------+
11 rows in set (0.00 sec)
2.进入或切换数据库
use databasename
3.显示当前选择使用的数据库
mysql> select database();
+------------+
| database() |
+------------+
| tars_stat |
+------------+
1 row in set (0.00 sec)
4.创建数据库
mysql> create DATABASE workRecord2022;
Query OK, 1 row affected (0.00 sec)
5.删除数据库
5.1 删除之前看一下有多少数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_base |
| db_cache_web |
| db_tars |
| db_tars_web |
| db_user_system |
| mysql |
| performance_schema |
| sys |
| tars_property |
| tars_stat |
| workRecord2022 |
+--------------------+
12 rows in set (0.00 sec)
5.2 删除一个不存在的数据库
mysql> DROP DATABASE IF EXISTS test;
Query OK, 0 rows affected, 1 warning (0.00 sec)(当前MySQL不存在test这个数据库,用这种方法会报告警)
mysql> DROP DATABASE test;
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist(当前MySQL不存(当前MySQL不存在test这个数据库,用这种方法直接报错)
5.3 删除一个存在的数据库-正常删除
mysql> DROP DATABASE IF EXISTS workRecord2022;
Query OK, 0 rows affected (0.00 sec)mysql>
5.4 查看删除之后当前MySQL存在的数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db_base |
| db_cache_web |
| db_tars |
| db_tars_web |
| db_user_system |
| mysql |
| performance_schema |
| sys |
| tars_property |
| tars_stat |
+--------------------+
11 rows in set (0.00 sec)