Write the SQL statement to create a database called 'movie_db'.

The automated "quotes" you're seeing aren't single quotes they are backticks. If you attempt to actually create a database in MySQL Workbench you'll see a syntax highlighting error like so:

I don't go over using backticks as they're optional. They are best used in circumstances where you're calling something the same as a keyword like the following example, a database call 'database':

CREATE SCHEMA database

You can utilize backticks like this:

CREATE SCHEMA `database`

The first statement will fail however the second will execute creating a database called 'database'.

One character out of place, for example the single quote or a backtick, no matter how similar they are, will cause unexpected results.

Hope that explains it a bit more and helps clarify any confusion with what you're seeing.

I believe this is a bug as well. I was just able to pass the challenge by typing CREATE SCHEMA movie_db; (no quotes) after several failed attempts. In the videos (and in the Workbench application) it shows clearly the usage of quotes around the database name. And Andrew makes a point of the fact that the words schema and database are interchangeable when creating new databases.

I'm having the same exact problem! It must be a bug. The challenge says: Write the SQL statement to create a database called 'movie_db'.

and when I try any of these:

CREATE SCHEMA 'movie_db'; CREATE SCHEMA movie_db; CREATE DATABASE 'movie_db'; CREATE DATABASE movie_db;

I get the same message: Bummer! Your SQL statement to create a new database called movie_db is wrong.

CREATE SCHEMA `movie_db`;

will pass the challenge also.

DATABASE FOUNDATIONS

Challenge Task 1 of 2 Write the SQL statement to create a database called movie_db.

CREATE SCHEMA MOVIE_DB;

Challenge Task 2 of 2 Update the SQL statement to include the keywords to make sure the server doesn't error if it already exists.

CREATE SCHEMA IF NOT EXISTS movie_db;