Treehouse | Community

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

roy chen
2,465 Points
I think i did it right.

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

roy chen
2,465 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
9,448 Points
REFERENCES and foreign keys syntax.

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

Max Green
9,448 Points
1 Answer
PRO

YA Abidakadr
Pro Student 2,017 Points
error

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

YA Abidakadr
Pro 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
PRO

Ciaran Wood
Pro Student 6,784 Points
sql playground disappears

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

Ciaran Wood
Pro Student 6,784 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
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
Daniele Fusari
37,133 Points
CREATE TABLE MEMBERS (ID PRIMARY KEY, FIRST_NAME, LAST_NAME, FAVORITE_ROCK)

Posted July 16, 2018 7:40pm by Daniele Fusari

Daniele Fusari
37,133 Points
1 Answer
Kendell Dancy
12,318 Points
What am I doing wrong here?

Posted July 12, 2018 8:46pm by Kendell Dancy

Kendell Dancy
12,318 Points
1 Answer
Deborah Watson
2,614 Points
Why does this fail in SQL Lite?

Posted July 12, 2018 6:23pm 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
mjmj
18,664 Points
Stuck is first Challenge Task of Creating and Modifying Databases

Posted July 11, 2018 5:49pm by mjmj

mjmj
18,664 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
0 Answers
PRO

Peter Chukwukelu
Pro 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
Pro Student 833 Points
1 Answer
PRO

Peter Chukwukelu
Pro 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
Pro 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
Kareem Jeiroudi
14,981 Points
Anyone had the problem that it kept adding the values 500 and -10, even after setting `PRAGMA FOREIGN_KEYS = on;`

Posted May 23, 2018 5:51pm by Kareem Jeiroudi

Kareem Jeiroudi
14,981 Points
4 Answers
Jason Tabaczynski
3,177 Points
Can't create table with the CREATE TABLE command

Posted May 12, 2018 6:56pm by Jason Tabaczynski

Jason Tabaczynski
3,177 Points
0 Answers
Adam Tatusko
16,542 Points
CONCERT ID

Posted February 14, 2018 8:42pm by Adam Tatusko

Adam Tatusko
16,542 Points
1 Answer

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