创建数据库:
CREATE database if not exists db_name;
CREATE {database | schema} [if not exists] db_name
[[default ] character set [=] charset_name]
[[ default ] collate [=] collation_name]
选择数据库:
USE db_name;
查看数据库:
SHOW databases;
SHOW schemas;
SHOW {databases | Schemas}
修改数据库:
ALTER {Database | Schema } [db_name]
[[default ] character set [=] charset_name]
[[ default ] collate [=] collation_name]
删除数据库:
DROP { Database | Schema } [if exists] db_name;