如果表已经创建好tb_user
1.增加字段stu_email,stu_blog
alter table tb_user add(stu_email varchar(50) default '123@163.com',stu_blog varchar(50));
2.删除字段stu_email:
alter table tb_user drop stu_email;
3.修改字段名:
mysql:
alter table tb_user change stu_blog stu_blog varchar(100);
oracle:
alter table tb_user rename column stu_blog to blig varchar(100);