MySql学习笔记【二、库相关操作】

命令规范

USE database_name
如：USE test

SHOW {DATABASES|SCHEMAS}
[LIKE 'pattern'|WHERE expr]
如：SHOW DATABASES;

SHOW CREATE DATABASE db_name
如： SHOW CREATE DATABASE test

CREATE {DATABASE|SCHEMA} [IF NOT EXISTS] db_name
[DEFAULT] CHARACTER SET [=] charset_name
如： CREATE DATABASE test CHARACTER SET utf8

ALTER {DATABASE|SCHEMA} [db_name]
[DEFAULT] CHARACTER SET [=] charset_name
如： ALTER DATABASE test CHARACTER SET GBK

DROP {DATABASE|SCHEMA} [IF EXISTS] db_name
如：DROP DATABASE test

SHOW WARNINGS;