Mysql数据库(一)创建数据库操作
1、show databases;数据库;
mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| library |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.13 sec)
2、create database test;创建数据库test
mysql> create database Test;
Query OK, 1 row affected (0.20 sec)
3、use test; 使用数据库
mysql> use test
Database changed
4、drop database test;删除数据库
mysql> drop database test;
Query OK, 0 rows affected (0.16 sec)