What's the mysql syntax to rename column in a table?
I try this:
ALTER TABLE static_content RENAME COLUMN title TO shorttext
MySQL said: Documentation
#1064 - 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 'COLUMN title TO shorttext' at line 1