After creating a table, there might be a change of requirements that forces changes to the structure of the table. If that happens, the table's structure can be modified without having to re-create the table. This section addresses some of the methods available for modifying the table structure and data. Add Columns For example, to add a column named Id to the eu_countries table, the following statement can be issued: ALTER TABLE eu_countries ADD Id INT(6) NOT NULL; That ALTER TABLE/ADD statement changes the table structure as follows: mysql> DESCRIBE eu_countries; +----------------------+-------------------+------+-----+-----------+--------+ | Field | Type | Null | Key | Default | Extra | +----------------------+-------------------+------+-----+-----------+--------+...
“The best way to be ready for the future is to invent it.”— John Sculley