查看指定数据库创建时的sql指令

mysql> show databases;
 -------------------- 
| Database           |
 -------------------- 
| information_schema |
| website            |
 -------------------- 

创建数据库

mysql> create database website;
Query OK, 1 row affected (0.04 sec)

创建数据库 如果不存在

mysql> create database if not exists website;
Query OK, 1 row affected (0.00 sec)

创建数据库 并设置编码

mysql> CREATE database if not exists website character set utf8;
Query OK, 0 rows affected, 1 warning (0.00 sec)

删除数据库

mysql> drop database if exists website;
Query OK, 0 rows affected (0.00 sec)

使用数据库

mysql> use website;
Database changed