![]() | shipper_name | varchar(60) | NO | | NULL | | | shipper_id | int | NO | PRI | NULL | auto_increment | ![]() | Field | Type | Null | Key | Default | Extra | In such situation you can use the ALTER TABLE statement to alter or change an existing table by adding, changing, or deleting a column in the table.Ĭonsider we've a shippers table in our database, whose structure is as follows: It is quite possible that after creating a table, as you start using it, you may discover you've forgot to mention any column or constraint or specified a wrong name for the column. ![]() In this tutorial you will learn how to alter or modify an existing table using SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |