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

Development Tools Database Foundations Manipulating Schema with SQL Altering Tables

TRUNCATE TABLE movies; Last step in the Altering Tables challenge. Can't get it to work??

Last step in the Altering Tables challenge. Can't get it to work??

Tried TRUNCATE TABLE movies; TRUNCATE movies;

Just keep getting "Bummer"

13 Answers

I submitted a message to Support on saturday. They still haven't changed anything. Either they're forgetting or the problem is more complex than they thought

Hi there,

Thanks for reaching out to us about this. We apologize for the inconvenience that this may have caused you. We're aware of this quiz bug and our developers are looking into it. If you have any other issues or questions, please let us know. We greatly appreciate your patience!

Best, Treehouse Support

I am getting the same error, I think there is a bug. My answer is: TRUNCATE TABLE movies;

Me too, tried

TRUNCATE TABLE movies;

and

TRUNCATE movies;

Was driving me crazy!

Me too, tried

TRUNCATE TABLE movies;

and

TRUNCATE movies;

Was driving me crazy!

"Database Foundations" challenges are now working!!!

input TRUNCATE TABLE movies

and keep returning

Oh no! There was a temporary issue running this code challenge. We've been notified and will investigate the problem.

If you continue experiencing problems, please contact support at help@teamtreehouse.com.

Jay McGavren
STAFF
Jay McGavren
Treehouse Teacher

We were having an issue with our MySQL code challenges over the weekend. The code that was responsible has been rolled back, and things seem to be working now. If anyone continues to experience problems, please let us know at help@teamtreehouse.com . Sorry for the trouble!

TRUNCATE TABLE movies;...................... THIS SHOULD WORK GUYS. JUST TRY IT

DATABASE FOUNDATIONS / SQL

Challenge Task 1 of 4

Rename the "actors" table to "t_actor".

RENAME TABLE actors to t_actor;

Challenge Task 2 of 4

Rename in one SQL statment both the "t_movie" table to "movies" and the "t_actor" table to "actors".

RENAME TABLE t_movie to movies, t_actor to actors

Challenge Task 3 of 4

Remove the "actors" table from the database.

DROP TABLE actors;

Challenge Task 4 of 4

Truncate the "movies" table.

TRUNCATE table movies;

Same error here

ok good I'm not the only one, Yeah I'm getting this bug as well.

still have a bug and not working

Yes, it is still not working.