Rename table with spaces mysql

Question

I have a table 'A B C' (with spaces, don't ask me why) in MySQL database. I have to rename it to 'ABC' This query doesn't work :(

rename table 'A B C' to 'ABC'

What should be the correct query?

I get the same usual error

'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version'

Answer 1

Escape the name with backticks.

rename table `A B C` to ABC

Answer 2

Use backticks:

rename table `A B C` to ABC;