<

MYSQL ALTER TABLE

MySQL ALTER is used to change the name of your table or any table field. It is also used to add or delete an existing column in a table.


MySQL Alter Table Syntax




ALTER TABLE table_name  
ADD new_column_name column_definition  
[ FIRST | AFTER column_name ];  



MySQL Alter Table Example



ALTER TABLE student
ADD mark varchar(40) NOT NULL;  















© copyright 2017-2022 Completedone pvt ltd.