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 trialFenian Noakes
Courses Plus Student 5,212 PointsRename the "actors" table to "t_actor". I cannot seem to get past this question. I think there is a bug
I have tried a few different ways to answer this - to no avail. I believe the correct answer is;
RENAME TABLE actors TO "t_actor";
I get this error; SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"t_actor"' at line 1
3 Answers
Jason Anders
Treehouse Moderator 145,860 PointsHi Fenian,
You're on the right track, you just need to delete the quotes you have around t_actor
.
RENAME TABLE actors TO t_actor;
Keep Coding! :)
Fenian Noakes
Courses Plus Student 5,212 PointsThanks Ted - your patience/insight on that is really appreciated. I have now done that. cheers again mate.
Fenian Noakes
Courses Plus Student 5,212 PointsHi Ted. Thanks for the heads-up on that. I will ensure to do that from now on. Cheers.
Ted Sumner
Courses Plus Student 17,967 PointsUpvoting is important for posts that are not your own, but best answer is a link under each answer. It turns the answer green and moves it to the top. The user also gets 12 points.
Fenian Noakes
Courses Plus Student 5,212 PointsFenian Noakes
Courses Plus Student 5,212 PointsHi Jason - awesome! many thanks. That did it. Really appreciate your quick helpful reply mate. Cheers!
Jason Anders
Treehouse Moderator 145,860 PointsJason Anders
Treehouse Moderator 145,860 PointsYou're welcome.
Ted Sumner
Courses Plus Student 17,967 PointsTed Sumner
Courses Plus Student 17,967 PointsFenian, please be sure to mark best answer when your forum questions are answered. It lets everyone know there is a solution to your question.