title: How can I change case of database name in MySQL?
body: <p>My Database name is <code>SPM</code> and I want to change it to <code>spm</code> (small letters).</p>
  
  <p>I tried using </p>
  
  <pre><code>RENAME DATABASE SPM TO spm;
  </code></pre>
  
  <p>, but I am getting the following error message:</p>
  
  <pre><code>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASE SPM to spm' at line 1
  </code></pre>
  
  <p><strong>My server version: 5.0.45</strong></p>