How do I run a query on a database whose name contains a space?

Question

In MySQL I created a database with name like de mo, and it contains a table like tablename. When I try to execute a query, for example:

select * from de mo.tablename

I am not able to execute that query. How can I do that?

Answer 1

You'll have to quote the database name:

SELECT * FROM `de mo`.tablename

Spaces in identifiers are best avoided really.

Answer 2

use backticks:

`de mo`