Mysql Alter Add Column In First or After

Topic

How to Use Mysql Alter Add Column First or MySQL Alter Add Column After Statements?

Explanation

MySQL Alter Add column First :
We can position the field using FIRST and AFTER modifiers. The following example query will place the new field as the first field in the table.
Mysql Alter Add Column In First or After
MySQL Alter Add column After :
We can also place the new field next to any of the field. The following example query will place the new field immediately after the field name.
Mysql Alter Add Column In First or After
Next we can see how to delete and change a field.