Difference between revisions of "Updating and Deleting MySQL Tables"
From Techotopia
(New page: Once a table has been created it is sometimes necessary) |
|||
| Line 1: | Line 1: | ||
| − | Once a table has been created it is | + | 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. | ||
Revision as of 18:12, 2 October 2007
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.
