MN PROJECT_STATUS,
DROP COLUMN EXPECT_RETURN,DROP COLUMN CURRENCY;
11.增加列
ALTER TABLE PROJECT
ADD COLUMN DICT_ID INT DEFAULT NULL COMMENT 'xxx' AFTER PROJECT_SITE,
ADD COLUMN INTRODUCE TEXT DEFAULT NULL COMMENT 'xx' AFTER DICT_ID,
ADD COLUMN STAGE INT DEFAULT NULL COMMENT 'xx' AFTER ID,
ADD COLUMN ATTACH_URI VARCHAR(8) DEFAULT NULL COMMENT 'xxx' AFTER INTRODUCE;
12.修改列
一般用MODIFY修改数据类型，CHANGE修改列名。
ALTER TABLE PROJECT CHANGE DICT_ID DICT_ID1 INT NOT NULL,
MODIFY PROJECT_STATUS TINYINT NOT NULL COMMENT 'xxx';
13.修改自增字段开始值
不同数据库此属性不一样，MYSQL 与ORACLE,MS SQL SERVER不一样，见具体文档
http://www.w3school.com.cn/sql/sql_autoincrement.asp
自增
ALTER TABLE persons AUTO_INCREMENT=1;