move column up or down in mysqldatabase code example

Example: how to move a columns location in mysql

ALTER TABLE table_name MODIFY password varchar(20) AFTER id