To add a column after a column in MySQL you can perform the following command:
alter table testtable add column newcolumn int(3) after somecolumn;
This will alter table “testtable” and add a new column called “newcolumn”, which is an 3 digit integer, after a column “somecolumn”.
Be on the lookout for any errors or warnings after this command is performed. Also remember to modify any code you have, if needed.