devxlogo

Adding a New Column in a Specific Position

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.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist