![]() The first_name column will be created as a varchar(35) NULL column and will appear after the last_name column in the table. The last_name field will be created as a varchar(40) NOT NULL column and will appear after the contact_id column in the table. It will also create as a NOT NULL column and will appear after the contact_id field in the table In above example MySQL Alter TABLE will add a column called last_name to the contacts table. Let’s see how to add a column in a MySQL table using the Alter Table statement. If this is not mentioned by default new column will be added to the end of the table.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |