mysql入门

连接仓库：

C:\Users\xxx>mysql -u root -p
Enter password: *********

创建仓库:

mysql> create database test;

显示仓库：

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| test |
+--------------------+
5 rows in set (0.00 sec)

删除仓库：

mysql> drop database test;
Query OK, 0 rows affected (0.13 sec)

 

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)