Changes

Once a table has been created it is sometimes inadvisable to modify it once it contains data. Sometimes, however, it is necessaryto 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.