How to move columns in a MySQL table

Question

Currently I am having the following MySQL table: Employees (empID, empName, department);

I want to change the table to the following: Employees (empID, department, empName);

I want to change only column positions.How can this be done using ALTER statements?

Answer 1

Hello @kartik,

If empName is a VARCHAR(50) column:

ALTER TABLE Employees MODIFY COLUMN empName VARCHAR(50) AFTER department;

You can also do this:

ALTER TABLE Employees CHANGE COLUMN empName empName VARCHAR(50) AFTER department;

Hope it helps!!
Thank you!!