Add a column after a column in MySQL

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.