myql 关键字after表示在某列的后面增加一列。
示例入下
USE database1
ALTER TABLE table1 ADD COLUMN `col_a` text COLLATE utf8_bin AFTER `col_x`,
ADD COLUMN `col_b` text COLLATE utf8_bin AFTER `col_a`
ADD COLUMN `col_c` text COLLATE utf8_bin AFTER `col_b`
myql 关键字after表示在某列的后面增加一列。
示例入下
USE database1
ALTER TABLE table1 ADD COLUMN `col_a` text COLLATE utf8_bin AFTER `col_x`,
ADD COLUMN `col_b` text COLLATE utf8_bin AFTER `col_a`
ADD COLUMN `col_c` text COLLATE utf8_bin AFTER `col_b`