place an existing column at first position in mysql
mysql
Solution
ALTER TABLE EMP_DTLS MODIFY COLUMN EMP_ID INT(10) FIRST
Just use the correct type,i used INT(10)
Problem
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.