增加:alter table tablename add name type;
删除:alter table tablename drop name ;
修改:alter table tablename change oldname newname type ;
修改属性:alter table tablename change oldname oldname type ;
重命名字段:alter table tablename change oldname newname integer;
删除:alter table tablename drop name ;
修改:alter table tablename change oldname newname type ;
修改属性:alter table tablename change oldname oldname type ;
重命名字段:alter table tablename change oldname newname integer;