–修改列名
ALTER TABLE name CHANGE column_name new_name new_type;
–修改表名
alter table test rename test1;
–添加表列
alter table test add column name varchar(10);
–删除表列
alter table test drop column name;
–修改列名
ALTER TABLE name CHANGE column_name new_name new_type;
–修改表名
alter table test rename test1;
–添加表列
alter table test add column name varchar(10);
–删除表列
alter table test drop column name;