1、数据库的查看
show databases;
show create database test_db\G;
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
注:这四个是数据库系统库
2、数据库的创建
create database test_db;
mysql> create database test_db;
Query OK, 1 row affected (0.00 sec)
mysql> show create database test_db\G;
*************************** 1. row ***************************
Database: test_db
Create Database: CREATE DATABASE `test_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */
1 row in set (0.00 sec)
3、数据库的删除
drop database test_db;
mysql> drop database test_db;
Query OK, 0 rows affected (0.01 sec)
mysql> show create database test_db\G;
ERROR 1049 (42000): Unknown database 'test_db'
ERROR:
No query specified