title: Rename INDEX Column
body: <p>I have a database with around 40 tables and need to rename every index column.</p>
  
  <p>IE USER a table has a bunch of fields like</p>
  
  <pre><code>user_id | user_username | user_password | etc...
  </code></pre>
  
  <p>I want to rename the ID columns just to id ie</p>
  
  <pre><code>id | user_username | user_password | etc...
  </code></pre>
  
  <p>But I keep getting mysql errors on the alter table command ie.</p>
  
  <p>ALTER TABLE database RENAME COLUMN user_id to id;</p>
  
  <p>Plus many different variations.</p>
  
  <p>Whats the best way to do this ?</p>
  
  <p>Hope you can advise </p>