Consider the following table that already exists:
CREATE TABLE 'NUMBERS_TABLE' ( 'ONE' INT(11) NULL DEFAULT NULL, 'THREE' INT(11) NULL DEFAULT NULL, 'FIVE' INT(11) NULL DEFAULT NULL ) COLLATE='utf8_bin' ENGINE=InnoDB ;
And we want to add a new column named TWO after column ONE, the following syntax must be used.
alter table NUMBERS_TABLE add TWO int after ONE;
The above line specifies to add a column TWO to be added after column ONE. This behavior is different from the normal ones where the new columns are added at the end of the column list in a given table.