Mysql创建和删除数据库

创建数据库

创建数据库的格式：

create database 数据库名;

示例：创建一个名为example的数据库

mysql> create database example;
Query OK, 1 row affected (0.02 sec)

mysql>
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bjpowernode        |
| example            |
| hellow             |
| mysql              |
| performance_schema |
| sql_180_76_242_2   |
| test               |
+--------------------+
8 rows in set (0.02 sec)

删除数据库

删除数据库的格式：

drop database 数据库名;

示例：删除example数据库:

mysql> drop database example;
Query OK, 0 rows affected (0.05 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bjpowernode        |
| hellow             |
| mysql              |
| performance_schema |
| sql_180_76_242_2   |
| test               |
+--------------------+
7 rows in set (0.00 sec)