Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Development Tools Database Foundations Manipulating Schema with SQL Removing Databases

Martina Carrington
Martina Carrington
15,754 Points

challenge task 2 of 2

Challenge Task 2 of 2

Update the SQL statement to include the keywords that would stop an error occurring when the movie_db doesn't exist.

Hi! I have try DROP DATABASE movie_db and create schema movie_DB.

2 Answers

Ken Alger
STAFF
Ken Alger
Treehouse Teacher

Martina;

Your question and code seems to be relating to Database creation, but the course links are for removing databases. Can you clarify which you are trying to do?

Ken

Martina Carrington
Martina Carrington
15,754 Points

Challenge Task 2 of 2

Update the SQL statement to include the keywords that would stop an error occurring when the movie_db doesn't exist.

Ken Alger
STAFF
Ken Alger
Treehouse Teacher

Martina;

Let's take a look at this challenge then.

Task 2

Update the SQL statement to include the keywords that would stop an error occurring when the movie_db doesn't exist.

From our first task, we know that we can do

DROP DATABASE movie_db

to drop the database. This task is an extension of that. The boiler plate syntax for what we are attempting, and you can take a look at the MySQL documentation for [DROP DATABASE syntax] would be:

DROP DATABASE IF EXISTS <database name>

See if that point you in the proper direction, and certainly post back if it does not.

Happy coding,

Ken