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

Posted by Lyric Abbott
Lyric Abbott
35,595 Points

mySQL

Remove the place_of_birth column from the 'actors' table.

Jeff Busch
Jeff Busch
19,287 Points

What have you tried so far?

3 Answers

Hugo Paz
Hugo Paz
15,622 Points
Hugo Paz
Hugo Paz
15,622 Points

ALTER TABLE table_name DROP COLUMN column_name

Kevin Fitzhenry
Kevin Fitzhenry
30,096 Points
Kevin Fitzhenry
Kevin Fitzhenry
30,096 Points

ALTER TABLE actors DROP COLUMN place_of_birth;

Ary de Oliveira
Ary de Oliveira
28,298 Points
Ary de Oliveira
Ary de Oliveira
28,298 Points

DATABASE / MySQL

Challenge Task 1 of 3

Add a column to the movies table called 'genre' and is of type VARCHAR up to 25 characters in length.

ALTER TABLE movies ADD COLUMN genre VARCHAR(25);

Challenge Task 2 of 3

In one statement, in the movies table rename the year to release_year and change the type to the type of YEAR.

ALTER TABLE movies CHANGE COLUMN year release_year Year;

Challenge Task 3 of 3

Remove the place_of_birth column from the 'actors' table.

ALTER TABLE actors DROP COLUMN place_of_birth;