How to rearrange the column position in MySQL [closed]

Question

How can I change the column position to first using ALTER query in MySQL table?

Answer 1

If you want your column at first position, you should use

ALTER TABLE tableName MODIFY COLUMN yourColumnName varchar(50) FIRST 

For example, if your table is

Employee{FirstName,LastName,EmpId}

And if you want to move EmpId to first position

ALTER TABLE Employee MODIFY COLUMN EmpId varchar(15) FIRST;