title: Error renaming a column in MySQL
body: <p>How do I rename a column in table <code>xyz</code>? The columns are:</p>
  
  <pre><code>Manufacurerid, name, status, AI, PK, int
  </code></pre>
  
  <p>I want to rename to <code>manufacturerid</code></p>
  
  <p>I tried using PHPMyAdmin panel, but I get this error:</p>
  
  <pre><code>MySQL said: Documentation
  #1025 - Error on rename of '.\shopping\#sql-c98_26' to '.\shopping\tblmanufacturer' (errno: 150)
  </code></pre>