Treehouse | Community | Making Changes to a Database

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

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

New No-Code Track! 🚀start learning today!

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

✨ 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

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

Posted on Mar 3, 2024 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 on Dec 11, 2023 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 on Dec 11, 2023 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 on Dec 11, 2023 by Nameer Jamal

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

Posted on Apr 29, 2023 by Alexander Tomashevskiy

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

Posted on Mar 13, 2023 by Fidelis Chime

Fidelis Chime
6,077 Points
1 Answer
Viktorija Kalniņa
1,652 Points
My script shows error, can' t get it right

Posted on Oct 4, 2022 by Viktorija Kalniņa

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

Posted on Dec 10, 2021 by Alejandro Aburto Salazar

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

Posted on Oct 14, 2021 by Danial Syafiq

Danial Syafiq
9,168 Points
1 Answer
keith gotohori
46 Points
how to create sql workspaces

Posted on Apr 14, 2021 by keith gotohori

keith gotohori
46 Points
1 Answer
Roxanne Reyes
9,006 Points
There's something wrong with this challenge. BUMMER IT'S NOT WORKING!

Posted on Feb 5, 2021 by Roxanne Reyes

Roxanne Reyes
9,006 Points
1 Answer
Tadjiev Codes
9,626 Points
What's wrong with my version?

Posted on May 26, 2020 by Tadjiev Codes

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

Posted on Mar 2, 2020 by graciela cañete

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

Posted on Jan 4, 2020 by roy chen

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

Posted on Aug 30, 2019 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 on Apr 4, 2019 by Francesco Sollitto

Francesco Sollitto
2,454 Points
1 Answer
PLUS

YA Abidakadr
Courses Plus Student 2,017 Points
error

Posted on Dec 28, 2018 by YA Abidakadr

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

Posted on Dec 27, 2018 by Susan Tan

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

Posted on Dec 17, 2018 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 on Oct 8, 2018 by Jorleni Maldonado

Jorleni Maldonado
14,398 Points
1 Answer
Deborah Watson
2,614 Points
Make sure you're creating all 4 columns: id, first_name, last_name, and favorite_rock_id.

Posted on Jul 18, 2018 by Deborah Watson

Deborah Watson
2,614 Points
2 Answers
Deborah Watson
2,614 Points
FOREIGN KEY CONSTRAINT IN SQL LITE

Posted on Jul 17, 2018 by Deborah Watson

Deborah Watson
2,614 Points
1 Answer
tonyhan
31,188 Points
CREATE TABLE ROCKS (ID PRIMARY KEY, NAME, TYPE, COLOR) doesn't seem to work, it just return's SQL Error

Posted on Jul 12, 2018 by tonyhan

tonyhan
31,188 Points
2 Answers
Joshua Johnson
702 Points
Having trouble with task 3 of Creating and Modifying Database

Posted on Jul 6, 2018 by Joshua Johnson

Joshua Johnson
702 Points
1 Answer
PLUS

Peter Chukwukelu
Courses Plus Student 833 Points
Hello please help me with the syntax for creating this table "Rocks" in this challenge.

Posted on Jun 19, 2018 by Peter Chukwukelu

Peter Chukwukelu
Courses Plus Student 833 Points
1 Answer
PLUS

Peter Chukwukelu
Courses Plus Student 833 Points
SELECT md.ModelName, ca.VIN, ca.StickerPrice FROM Model AS md INNER JOIN car AS ca ON md.ModelID, md.MakeID = ca.CarID;

Posted on Jun 17, 2018 by Peter Chukwukelu

Peter Chukwukelu
Courses Plus Student 833 Points
1 Answer
Troy Erby
6,332 Points
Trouble inserting Primary Key

Posted on May 24, 2018 by Troy Erby

Troy Erby
6,332 Points
2 Answers

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