Treehouse | Community | Making Changes to a Database

You found it first ⚡ 50% off any plan for 6 months, exclusive to new subscribers for a limited time only.

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

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

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Daniel Benisti
1,466 Points
What's wrong with my query?

Posted March 3, 2024 4:40pm by Daniel Benisti

Daniel Benisti
1,466 Points
0 Answers
Nameer Jamal
309 Points
Now recreate the MEMBERS table with the new FAVORITE_ROCK_ID column, and make sure it has a foreign key constraint to th

Posted December 11, 2023 9:51am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Nameer Jamal
309 Points
Now, in the MEMBERS table, we'd like to change the FAVORITE_ROCK column to be FAVORITE_ROCK_ID, and it should be a forei

Posted December 11, 2023 9:21am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Nameer Jamal
309 Points
create a table named ROCKS with the following columns: ID, NAME, TYPE, COLOR. And make sure that ID is a primary key.

Posted December 11, 2023 9:01am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Alexander Tomashevskiy
8,326 Points
Hello, Please help me, what wrong with my command?

Posted April 29, 2023 1:59pm by Alexander Tomashevskiy

Alexander Tomashevskiy
8,326 Points
1 Answer
Fidelis Chime
6,077 Points
ADD FOREIGN KEY

Posted March 13, 2023 5:42am by Fidelis Chime

Fidelis Chime
6,077 Points
1 Answer
Nicholas Angelini
1,538 Points
Receiving errors in sql playground launchpad.

Posted October 23, 2022 4:06pm by Nicholas Angelini

Nicholas Angelini
1,538 Points
2 Answers
Viktorija Kalniņa
1,652 Points
My script shows error, can' t get it right

Posted October 4, 2022 1:47pm by Viktorija Kalniņa

Viktorija Kalniņa
1,652 Points
2 Answers
Alejandro Aburto Salazar
7,733 Points
Adding foreign key not working

Posted December 10, 2021 8:22am by Alejandro Aburto Salazar

Alejandro Aburto Salazar
7,733 Points
2 Answers
Danial Syafiq
9,168 Points
error on challenge 3

Posted October 14, 2021 4:11pm by Danial Syafiq

Danial Syafiq
9,168 Points
1 Answer
Beau Coplin
7,903 Points
Different Approach

Posted June 1, 2021 8:17pm by Beau Coplin

Beau Coplin
7,903 Points
0 Answers
keith gotohori
46 Points
how to create sql workspaces

Posted April 14, 2021 8:52pm by keith gotohori

keith gotohori
46 Points
1 Answer
Kevin Kern
1,472 Points
I am able to complete the exercise in SQL playground but not the exercise prompt. Is there a difference?

Posted March 8, 2021 3:49pm by Kevin Kern

Kevin Kern
1,472 Points
1 Answer
Roxanne Reyes
9,006 Points
There's something wrong with this challenge. BUMMER IT'S NOT WORKING!

Posted February 5, 2021 4:04pm by Roxanne Reyes

Roxanne Reyes
9,006 Points
1 Answer
Colton Shaw
12,634 Points
Why would we drop the table each time we are adding data?

Posted October 9, 2020 2:14pm by Colton Shaw

Colton Shaw
12,634 Points
1 Answer
Tadjiev Codes
9,626 Points
What's wrong with my version?

Posted May 26, 2020 11:30am by Tadjiev Codes

Tadjiev Codes
9,626 Points
4 Answers
graciela cañete
421 Points
The exercise is doesn´t working

Posted March 2, 2020 6:47pm by graciela cañete

graciela cañete
421 Points
2 Answers
roy chen
2,659 Points
I think i did it right.

Posted January 4, 2020 11:46pm by roy chen

roy chen
2,659 Points
1 Answer
Dharmesh Nayee
1,090 Points
Why does my foreign key constrant not work?

Posted August 30, 2019 7:13pm by Dharmesh Nayee

Dharmesh Nayee
1,090 Points
3 Answers
Dharmesh Nayee
1,090 Points
I get the Bummer message saying that i need to add the 4 columns. What is wrong with my code?

Posted August 29, 2019 9:00pm by Dharmesh Nayee

Dharmesh Nayee
1,090 Points
3 Answers
Francesco Sollitto
2,454 Points
I HAVE ADDED THE PRIMARY KEY ON ID, WHY YOU KEEP REPEATING THE SAME BUMMER????

Posted April 4, 2019 9:03am by Francesco Sollitto

Francesco Sollitto
2,454 Points
1 Answer
Max Green
12,517 Points
REFERENCES and foreign keys syntax.

Posted January 18, 2019 4:17am by Max Green

Max Green
12,517 Points
1 Answer
PLUS

YA Abidakadr
Courses Plus Student 2,017 Points
error

Posted December 28, 2018 8:59am by YA Abidakadr

YA Abidakadr
Courses Plus Student 2,017 Points
1 Answer
Susan Tan
381 Points
my answer does not work

Posted December 27, 2018 11:44pm by Susan Tan

Susan Tan
381 Points
1 Answer
Otec Perez Glass
7,678 Points
Is not Working!

Posted December 17, 2018 12:38am by Otec Perez Glass

Otec Perez Glass
7,678 Points
3 Answers
Jorleni Maldonado
14,398 Points
Not sure what I'm missing here...

Posted October 8, 2018 8:17pm by Jorleni Maldonado

Jorleni Maldonado
14,398 Points
1 Answer
PLUS

Ciaran Wood
Courses Plus Student 6,787 Points
sql playground disappears

Posted September 21, 2018 8:33am by Ciaran Wood

Ciaran Wood
Courses Plus Student 6,787 Points
0 Answers
Gregory Ely
787 Points
I am pretty sure I have typed in the 'create' parameter correctly. I also attempted to remove table and it said no such

Posted August 25, 2018 2:09am by Gregory Ely

Gregory Ely
787 Points
4 Answers
dwan west
165 Points
error when running queries

Posted August 9, 2018 12:45am by dwan west

dwan west
165 Points
1 Answer
YURI PAPINIAN
11,838 Points
How to rename a column name?

Posted August 5, 2018 9:43pm by YURI PAPINIAN

YURI PAPINIAN
11,838 Points
1 Answer

Prev Page 1 of 2 Next

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