MySQL表结构升级语句

表相关

删除列

String sql = "ALTER TABLE `%1$s` DROP COLUMN `%2$s`, DROP COLUMN `%3$s`;";

新增列

"ALTER TABLE `%1$s` ADD COLUMN `%3$s` BIGINT AFTER `%2$s`;";
"ALTER TABLE `%1$s` ADD COLUMN `%3$s` VARCHAR(255) AFTER `%2$s`;";
"ALTER TABLE `%1$s` ADD COLUMN `%3$s` INT AFTER `%2$s`;";
一条语句顺序增加多列
String sql = "ALTER TABLE `%1$s` ADD COLUMN `%3$s` VARCHAR(1023) AFTER `%2$s`, " 
					+ "ADD COLUMN `%4$s` VARCHAR(1023) AFTER `%3$s`, "
					+ "ADD COLUMN `%5$s` VARCHAR(1023) AFTER `%4$s`, "
					+ "ADD COLUMN `%6$s` VARCHAR(1023) AFTER `%5$s`, "
					+ "ADD COLUMN `%7$s` VARCHAR(1023) AFTER `%6$s`";
					+ 
ALTER TABLE tbl_test ADD COLUMN _test1 VARCHAR(255) NULL after _id, 
ADD COLUMN _test2 INT NULL after _test1;

添加索引:
"ALTER TABLE `%1$s` ADD INDEX `%2$s` (`%2$s` ASC);" #%2$s填入列名
添加联合索引：
ALTER TABLE table_name ADD INDEX (column1,column2);

修改列:
sql = "alter table `%1$s` modify column `%2$s` varchar(255);";
sql = "ALTER TABLE `%1$s` MODIFY COLUMN `%2$s` TEXT;";