Treehouse | Community | Making Changes to a Database

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

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
40,669 Points
CREATE TABLE MEMBERS (ID PRIMARY KEY, FIRST_NAME, LAST_NAME, FAVORITE_ROCK)

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

Daniele Fusari
40,669 Points
1 Answer
Kendell Dancy
15,158 Points
What am I doing wrong here?

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

Kendell Dancy
15,158 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
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
Kareem Jeiroudi
14,984 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,984 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
1 Answer
Adam Tatusko
16,589 Points
CONCERT ID

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

Adam Tatusko
16,589 Points
1 Answer

Prev Page 2 of 2 Next

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

Deborah Watson

Deborah Watson

Deborah Watson

Deborah Watson

Daniele Fusari

Daniele Fusari

Kendell Dancy

Kendell Dancy

Deborah Watson

Deborah Watson

tonyhan

tonyhan

mjmj

mjmj

Joshua Johnson

Joshua Johnson

Peter Chukwukelu

Peter Chukwukelu

Peter Chukwukelu

Peter Chukwukelu

Troy Erby

Troy Erby

Kareem Jeiroudi

Kareem Jeiroudi

Jason Tabaczynski

Jason Tabaczynski

Adam Tatusko

Adam Tatusko