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);

How can this be done using ALTER statements?

Note: I want to change only column positions.

Answer 1

If you want the syntax for using an alias in an update statement on SQL server, then use the code as follows:

Query:

UPDATE Q

SET Q.TITLE = 'TEST'

FROM HOLD_TABLE Q

WHERE Q.ID = 101;

Note: Although alias is not mandatory to use here.