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!
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
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"
Oziel Perez61,321 Points
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
Yvette Alasti17,589 Points
I am getting the same error, I think there is a bug. My answer is: TRUNCATE TABLE movies;
"Database Foundations" challenges are now working!!!
Jay McGavrenTreehouse 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 email@example.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
Yes, it is still not working.