Mysql Alter Add Column In First or After
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 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.
Next we can see how to delete and change a field.
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.
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.
