dcsimg
 

Submitted by: M S Sridhar(sridhar.ms@gmail.com)

Thursday Oct 4th 2018 by M S Sridhar

Language: SQL, Expertise: Intermediate - Learn how to specify the location of a new column, rather than just adding it to the end of the current table.

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.

Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved