How do I run a query on a database with a name containing a space?

Question

In MySQL I create a database 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?

Answer 1

You'll have to quote the database name:

SELECT * FROM `de mo`.tablename

Spaces in identifiers are best avoided really.

Answer 2

It is necessary to quote the name. Usually backticks are used:

select * from `de mo`.tablename

Answer 3

use backticks:

`de mo`