MOVING A COLUMN IN MYSQL code example

Example: how to move a columns location in mysql

ALTER TABLE table_name MODIFY password varchar(20) AFTER id