Selecting a database in mysql with spaces in its name Selecting a database in mysql with spaces in its name mysql mysql

Selecting a database in mysql with spaces in its name


mysql database console spaces

You should try using back ticks ("`") to quote your database name. Generally speaking, it's probably better to use a naming convention to eliminate white space, e.g.

USE `StudentRegistration`;

or

USE `student_registration`;

mysql database console spaces

You have two options.

1 Enclose the database name in backticks or single quotes.

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

2 Escape the white space character.

USE student\ registration;

Oddly enough this produces.

ERROR: Unknown command '\ '.

But still changes the database.

mysql database console spaces

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

use `student registration`;

At least that would be yours.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last