move column after mysql alter query code example

Example 1: how to move a columns location in mysql

ALTER TABLE table_name MODIFY password varchar(20) AFTER id

Example 2: how to move a column to different spot mysql

ALTER TABLE TableEx MODIFY COLUMN colName VARCHAR(50) AFTER colName2;