Treehouse | Community | Altering Tables

NOTICE: On Friday Nov 6, Workspaces will be temporarily unavailable for maintenance.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Join the Treehouse affiliate program and earn 25% recurring commission! 🤑

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

A X
12,842 Points
Writing SQL Code in an Outdated Version Number: What Happens?

Posted April 1, 2016 5:19pm by A X

A X
12,842 Points
1 Answer
Sean Flanagan
33,237 Points
DELETE vs DROP vs TRUNCATE

Posted January 5, 2016 12:48am by Sean Flanagan

Sean Flanagan
33,237 Points
1 Answer
Sean Flanagan
33,237 Points
DELETE vs DROP vs TRUNCATE

Posted January 5, 2016 12:48am by Sean Flanagan

Sean Flanagan
33,237 Points
3 Answers
Sean Flanagan
33,237 Points
Can't connect to MySQL server

Posted January 3, 2016 4:05pm by Sean Flanagan

Sean Flanagan
33,237 Points
6 Answers
Elena Paraschiv
9,938 Points
DDL and DML

Posted November 10, 2015 11:53am by Elena Paraschiv

Elena Paraschiv
9,938 Points
1 Answer
Magnus Rydberg
4,683 Points
Why are so many SQL keywords optional?

Posted October 21, 2015 2:06pm by Magnus Rydberg

Magnus Rydberg
4,683 Points
2 Answers
Seth Warner
5,348 Points
What if you wanted to just change the column type, and not the name as well?

Posted October 15, 2015 8:41pm by Seth Warner

Seth Warner
5,348 Points
3 Answers
PLUS

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

Posted September 11, 2015 2:55am by Fenian Noakes

Fenian Noakes
Courses Plus Student 5,212 Points
3 Answers
Philip Bessa
5,396 Points
Challenge broken? (task 1)

Posted September 9, 2015 3:46pm by Philip Bessa

Philip Bessa
5,396 Points
1 Answer
Andrew Walters
8,876 Points
Drop if exists

Posted September 8, 2015 3:45am by Andrew Walters

Andrew Walters
8,876 Points
2 Answers
MUZ140679 Tinashe Matanda
7,657 Points
Remove the "actors"table from the database

Posted July 23, 2015 1:10pm by MUZ140679 Tinashe Matanda

MUZ140679 Tinashe Matanda
7,657 Points
2 Answers
MUZ140996 Simbarashe Gombedza
3,813 Points
Database Foundations

Posted July 21, 2015 7:41am by MUZ140996 Simbarashe Gombedza

MUZ140996 Simbarashe Gombedza
3,813 Points
0 Answers
MUZ140996 Simbarashe Gombedza
3,813 Points
Update SQL Statement

Posted July 20, 2015 1:35pm by MUZ140996 Simbarashe Gombedza

MUZ140996 Simbarashe Gombedza
3,813 Points
1 Answer
MUZ140996 Simbarashe Gombedza
3,813 Points
Database foundation

Posted July 20, 2015 9:53am by MUZ140996 Simbarashe Gombedza

MUZ140996 Simbarashe Gombedza
3,813 Points
1 Answer
muz141018susanmusonza
3,695 Points
help me an stuck on this one

Posted July 13, 2015 5:42am by muz141018susanmusonza

muz141018susanmusonza
3,695 Points
1 Answer
Alina Shrestha
3,178 Points
Update the SQL statement to include the keywords that would stop an error occurring when the movie_db doesn't exist.

Posted July 12, 2015 6:47am by Alina Shrestha

Alina Shrestha
3,178 Points
0 Answers
MUZ140264 Tsitsi Mupamombe
4,195 Points
HOW DO I ADD COLUMN

Posted June 22, 2015 12:20pm by MUZ140264 Tsitsi Mupamombe

MUZ140264 Tsitsi Mupamombe
4,195 Points
5 Answers
PLUS

Martina Carrington
Courses Plus Student 15,807 Points
Challenge Task 2 of 2 Update the SQL statement to include the keywords

Posted June 7, 2015 2:37pm by Martina Carrington

Martina Carrington
Courses Plus Student 15,807 Points
1 Answer
PLUS

Martina Carrington
Courses Plus Student 15,807 Points
challenge task 2 of 2

Posted June 6, 2015 2:43am by Martina Carrington

Martina Carrington
Courses Plus Student 15,807 Points
2 Answers
Bruce Berdine
13,607 Points
TRUNCATE TABLE movies; Last step in the Altering Tables challenge. Can't get it to work??

Posted January 24, 2015 1:22am by Bruce Berdine

Bruce Berdine
13,607 Points
13 Answers
Nure México
25,840 Points
What's the main difference between database and schema?

Posted January 2, 2015 9:41pm by Nure México

Nure México
25,840 Points
2 Answers
Evan Shellborn
4,827 Points
Why does he leave us with truncated tables?

Posted December 10, 2014 5:28pm by Evan Shellborn

Evan Shellborn
4,827 Points
2 Answers
ricardogutierrez
11,349 Points
Workbench 6: 'CHANGE' or 'CHANGED' keyword

Posted May 9, 2014 7:37pm by ricardogutierrez

ricardogutierrez
11,349 Points
2 Answers
shen lei
495 Points
Bug in Removing db Challenge Task?

Posted February 17, 2014 7:28pm by shen lei

shen lei
495 Points
0 Answers
Jason Bean
3,490 Points
Quiz Question Help

Posted February 13, 2014 3:16pm by Jason Bean

Jason Bean
3,490 Points
1 Answer

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.