Adding a New Column in a Specific Position

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Related Posts