How to change the column position of MySQL table without losing column data?

Question

I want to change the column positions of my database table without losing data.

For example:

Current table:

+----+------+-------+----------+ | id | name | email | password | +----+------+-------+----------+ 

to

+----+----------+------+-------+ | id | password | name | email | +----+----------+------+-------+ 

Answer 1

Try this:

ALTER TABLE table_name MODIFY password varchar(20) AFTER id 

Answer 2

Hearaman's answer is correct; but if you are using phpMyAdmin, there is a visual and practical way to do that.

1. Open the table
2. Choose the "Structure" tab
3. Click on "Move columns"
4. Drag and drop column names