http://blog.163.com/yangzhanghui_job/blog/static/17957506220127139440423/
use test;
create table teachers(
id int primary key,
name varchar(20)
);
修改表结构--添加字段:
alter table teachers
add column age int not null default 0 after name;(在姓名字段后添加)
修改表结构--删除字段:
alter table teachers drop column age;
添加主键
alter table teachers add primary key (id);
删除主键
alter table teachers drop primary key;
重命名列
alter table teachers change age sex int;
改变列的类型
alter table teachers change sex sex varchar(2) not null;
重命名表
alter table teachers rename boss;
//给主键添加自动增长
alter table boss change id id int(20) auto_increment;
//不能直接删除主键,先删自动增长,再删主键
alter table boss change id id int(10);
alter table boss drop primary key;
查看字符集
/s;
//以下未经过测试
//修改数据库的字符集
//修改表的字符集
alter database test default character set utf8;
alter table teachers default character set utf8;