mysql教程之操作数据库

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

SHOW {DATABSES | SCHEMAS} [LIKE pattern | WHERE expr]

SHOW WARNINGS;

SHOW CREATE DATABASE db_name;

CREATE DATABASE db_name IF NOT EXISTS CHARACTER SET gbk;

ALTER {DATABASE | SCHEMA} [db_name] [DEFAULT] CHARACTER SET [=] charset_name

DROP {DATABASE | SCHEMA} [IF EXISTS] db_name

CREATE TABLE [IF NOT EXISTS] table_name(
column_name data_type,
...
)