My Database name is SPM and I want to change it to spm (small letters).
I tried using
RENAME DATABASE SPM TO spm;
, but I am getting the following error message:
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
My server version: 5.0.45