Google News
logo
MySQL - Interview Questions
How to add columns in MySQL?
A column is a series of cells in a table that stores one value for each row in a table. We can add columns in an existing table using the ALTER TABLE statement as follows :
 
ALTER TABLE table_name     
    ADD COLUMN column_name column_definition [FIRST|AFTER existing_column];

 

Advertisement