place an existing column at first position in mysql [duplicate]

Question

please tell me how to place an existing column(contained values) at first position in mysql. Suppose i have a table EMP_DTLS and there are columns like NAME, SALARY, DOJ, DOB, EMAIL_ID, AND EMP_ID contains values in every columns. Now i want to place this EMP_ID at first position. Thanks in advance.

I have tried the queries those are discussed here previously but those aren't working for me.

Answer 1

ALTER TABLE EMP_DTLS MODIFY COLUMN EMP_ID INT(10) FIRST

Just use the correct type,i used INT(10)