Choosing a database in mysql with spaces in its name

Question

I want to select my specific database in the mysql console, but the problem is that my database name has a gap between them and mysql ignores the part after the space. For example, when I give the command:

use 'student registration' 

I get a message:

 cannot find database 'student' 

Answer 1

You should try using backticks ("` ") to indicate your database name. Generally speaking, it is probably best to use a naming convention to bridge the gap, for example.

 USE `StudentRegistration`; 

or

 USE `student_registration`; 

Answer 2

You have two options.

1 Paste the database name in backtick or single quotation marks.

 USE `student registration`; USE 'student registration'; 

2 Escape over the space character.

USE student\ registration;

Oddly enough, it gives.

ERROR: Unknown command '\'.

But still the database changes.

Answer 3

When I had to deal with other people's tables with spaces, the following works:

 use `student registration`; 

At least it will be yours.

Answer 4

Use double quotes instead of single, double quotes working for me:

 USE "student registration"; 

Answer 5

To do this, you need to use square brackets:

 Use [student registration] 

Answer 6

Use student registration without quotes.