Schema managementMySQL
ALTER TABLE
Modify table structure by adding columns or indexes.
Command
ALTER TABLE ADD COLUMN VARCHAR(255) NOT NULL;
Example usage
Evolve schema incrementally without downtime.
ALTER TABLE <table> ADD COLUMN <column> VARCHAR(255) NOT NULL;ALTER TABLE <table> ADD INDEX idx_<col> (<column>);Related tags
Schema managementdatabasesqlinnodb