CODE EXAMPLE FOR PYTHON

add a new column after a particular column

ALTER TABLE `table_name` 
 ADD COLUMN `column_name2` varchar(255)
 AFTER `column_name1`;