Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Martina Carrington
15,754 PointsUpdate the SQL statement to include the keywords that would stop an error occurring when the movie_db doesn't exist.
Hi! i have try CREATE DATABASE IF NOT EXISTS movie_db; and i keep getting bummer . I'm wondering what im doing wrong ?
3 Answers
Chris Adamson
132,143 PointsIt looks like you have too much in your sql statement:
CREATE DATABASE IF NOT EXISTS movie_db and SQL if not exist movie_db
should be:
CREATE DATABASE IF NOT EXISTS movie_db;
MUZ140582 Felix Matshona
5,645 Pointswhats wrong with my code CREATE DATABASE IF NOT EXISTS movie_db;
thanx guys
MUZ141012 Tapiwa Jaravani
12,676 PointsIT SHOULB 'DROP DATABASE IF EXISTS movie_db;'
Martina Carrington
15,754 PointsMartina Carrington
15,754 Pointsthanks chris :)