Treehouse | Community | Making Changes to a Database

🚀 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

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
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
keith gotohori
46 Points
how to create sql workspaces

Posted April 14, 2021 8:52pm 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 February 5, 2021 4:04pm by Roxanne Reyes

Roxanne Reyes
9,006 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
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
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
Deborah Watson
2,614 Points
Make sure you're creating all 4 columns: id, first_name, last_name, and favorite_rock_id.

Posted July 18, 2018 8:25pm by Deborah Watson

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

Posted July 17, 2018 6:06pm 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 July 12, 2018 3:07am by tonyhan

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

Posted July 6, 2018 1:52pm 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 June 19, 2018 6:56pm 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 June 17, 2018 6:09pm by Peter Chukwukelu

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

Posted May 24, 2018 5:29pm 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.