库的操作

显示已有数据库

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

创建数据库

mysql> create database stu;
Query OK, 1 row affected (0.00 sec)
mysql> -- 或者
mysql> create database if not exists stu;
Query OK, 1 row affected, 1 warning (0.00 sec)

查看创建数据库

mysql> show create database stu;
+----------+----------------------------------------------------------------+
| Database | Create Database                                                |
+----------+----------------------------------------------------------------+
| stu      | CREATE DATABASE stu /!40100 DEFAULT CHARACTER SET latin1 / |
+----------+----------------------------------------------------------------+
1 row in set (0.00 sec)

修改数据库编码集

mysql> alter database stu charset=utf8;
Query OK, 1 row affected (0.00 sec)

删除数据库

mysql> drop database stu;
Query OK, 0 rows affected (0.02 sec
mysql> -- 或者
mysql> drop database if exists stu;
Query OK, 0 rows affected (0.00 sec)