dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Adding a New Column in a Specific Position

Learn how to specify the location of a new column, rather than just adding it to the end of the current table.


advertisement

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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.

 

Visit the DevX Tip Bank

 





   
Sridhar M S. is a Java developer from Bangalore, India. He holds a master's degree in Computer Science.
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date