MySQL 修改表结构
添加列
ALTER TABLE table_name ADD COLUMN column_name int DEFAULT 100 NOT NULL
修改列
ALTER TABLE table_name MODIFY COLUMN column_name int DEFAULT 100 NOT NULL
alter table `table_name` modify column `column_name` int default 0 not null
删除列
ALTER TABLE table_name DROP COLUMN column_name