title: Rename a column in MySQL
body: <p>I am trying to rename a column in MySQL community server 5.5.27 using this SQL expression:</p>
  
  
  
  <pre class="lang-sql prettyprint-override"><code>ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name;
  </code></pre>
  
  <p>I also tried</p>
  
  <pre class="lang-sql prettyprint-override"><code>ALTER TABLE table_name RENAME old_col_name TO new_col_name;
  </code></pre>
  
  <p>But it says:</p>
  
  <blockquote>
    <p>Error: check the Manual that corresponds to your MySQL server version</p>
  </blockquote>