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

Posted by Fenian Noakes
Fenian Noakes
Courses Plus Student 5,212 Points

Rename 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
MOD
Jason Anders
Treehouse Moderator 145,860 Points
Jason Anders
Jason Anders
Treehouse Moderator 145,860 Points

Hi 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
Fenian Noakes
Courses Plus Student 5,212 Points

Hi Jason - awesome! many thanks. That did it. Really appreciate your quick helpful reply mate. Cheers!

Ted Sumner
Ted Sumner
Courses Plus Student 17,967 Points

Fenian, please be sure to mark best answer when your forum questions are answered. It lets everyone know there is a solution to your question.

Fenian Noakes
PLUS
Fenian Noakes
Courses Plus Student 5,212 Points
Fenian Noakes
Fenian Noakes
Courses Plus Student 5,212 Points

Thanks Ted - your patience/insight on that is really appreciated. I have now done that. cheers again mate.

Fenian Noakes
PLUS
Fenian Noakes
Courses Plus Student 5,212 Points
Fenian Noakes
Fenian Noakes
Courses Plus Student 5,212 Points

Hi Ted. Thanks for the heads-up on that. I will ensure to do that from now on. Cheers.

Ted Sumner
Ted Sumner
Courses Plus Student 17,967 Points

Upvoting 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.