创建数据库: create database [name];
查看数据库::show databases;
删除数据库: drop database [name];
查看支持的数据库引擎:show engines; show variables like 'have%';
查看默认引擎:show variables like 'storage_engine';
查看表结构:describe [name]; 可以简写成DESC
show create table [name]\G;
修改表名:alter table [old name] rename to [new name];
修改表的数据类型:alter table [name] modify [att name] [data type];
修改表的字段名:alter table [name] change [old att name] [new att name] [new data type];
增加字段:alter table [name] add [att name] [data type] [constraint] [first|after att2];
删除字段:alter table [name] drop [att name];
修改表的存储引擎:alter table [name] engine=[name];
删除表的外键:alter table [name] drop foreign key [name];
删除表:drop table [name];