mysql add column after another column code example

Example: insert column after column mysql

ALTER TABLE tbl_name
ADD COLUMN new_column_name VARCHAR(15) AFTER existing_column_name;