Updating and Deleting MySQL Tables

From Techotopia
Revision as of 18:12, 2 October 2007 by Neil (Talk | contribs)

Jump to: navigation, search

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.