Updating and Deleting MySQL Tables
Once a table has been created it is inadvisable to modify it once it contains data. Sometimes, however, it is necessary to make a change and such changes can be made using the SQL statements. It is also possible to delete an existing table from a database. In this chapter both of this topics will be covered.
Altering a MySQL Table
A pre-existing table in a database may be modified using the SQL ALTER TABLE statement.