title: How to change the column position of MySQL table without losing column data?
body: <p>I want to change the column positions of my database table without losing data.</p>
  
  <p><strong>For example:</strong></p>
  
  <p>Current table:</p>
  
  <pre><code>+----+------+-------+----------+
  | id | name | email | password |
  +----+------+-------+----------+
  </code></pre>
  
  <p>to</p>
  
  <pre><code>+----+----------+------+-------+
  | id | password | name | email |
  +----+----------+------+-------+
  </code></pre>