title: How to move columns in a MySQL table?
body: <p>Currently I am having the following MySQL table: <code>Employees (empID, empName, department);</code></p>
  
  <p>I want to change the table to the following: <code>Employees (empID, department, empName);</code></p>
  
  <p>How can this be done using <code>ALTER</code> statements?</p>
  
  <p>Note: I want to change only column positions. </p>