mysql 基本操作

[size=large]1. 表操作[/size]
[size=medium]1.1创建表[/size]

create table user (
`id` int auto_increment not null comment 'id',
`class_id` int comment '班级id',
`name` varchar not null comment '学生姓名',
primary key `id`
)

[size=medium]1.2修改表名[/size]

alter table user rename to my_user;

[size=large]2. 字段操作[/size]
[size=medium]2.1添加字段[/size]

alter table user add e_mail varchar comment '邮箱';

[size=medium]2.2修改字段[/size]

alter table user change class_id grade_id int comment '年级id';

[size=medium]2.3删除字段[/size]

alter table user drop column class_id;

[size=large]3. 索引操作[/size]

show index in user;
alter table user add index idx_class_id(class_id);
alter table user drop index idx_class_id;

[size=large]4. 备份表[/size]

create tabel user_back like user;
insert into user_back select * from user;
// 备份过程中注意先删除索引，这样插入速度要快很多很多，比如alter table user drop primary key `id`, drop index `class_id`.