Treehouse | Community | Keys and Auto-Incrementing Values

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

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

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Pierce Mulligan
1,106 Points
What is the issue with my PRIMARY KEY?

Posted August 10, 2015 3:23pm by Pierce Mulligan

Pierce Mulligan
1,106 Points
1 Answer
MUZ140886 Mandava
4,675 Points
YOU SHOULD TRY CREATE TRY WRITE TABLE

Posted July 28, 2015 10:29am by MUZ140886 Mandava

MUZ140886 Mandava
4,675 Points
1 Answer
STEVE NODINE
2,910 Points
What is wrong with this? Challlenge 3 of 3 ALTER TABLE movies ADD COLUMN genre_id INTEGER NULL, ADD CONSTRAINT FOREIGN

Posted July 26, 2015 10:18pm by STEVE NODINE

STEVE NODINE
2,910 Points
2 Answers
MUZ140996 Simbarashe Gombedza
3,813 Points
Database Foundations

Posted July 23, 2015 8:53am by MUZ140996 Simbarashe Gombedza

MUZ140996 Simbarashe Gombedza
3,813 Points
1 Answer
Taylor Rogers
806 Points
I am having trouble on the second task. I'm not sure I'm understanding this correctly.

Posted July 20, 2015 4:33pm by Taylor Rogers

Taylor Rogers
806 Points
2 Answers
gregsmith5
32,615 Points
movies_db download link

Posted July 16, 2015 8:22pm by gregsmith5

gregsmith5
32,615 Points
0 Answers
Daniel Schwemmlein
4,960 Points
don't know whats missing in my constraint

Posted July 5, 2015 6:44pm by Daniel Schwemmlein

Daniel Schwemmlein
4,960 Points
0 Answers
Geoffrey Neal
30,298 Points
PRIMARY KEY returning null.

Posted July 3, 2015 3:44pm by Geoffrey Neal

Geoffrey Neal
30,298 Points
1 Answer
Maria De Bruyn
4,635 Points
Database constraint and references

Posted June 29, 2015 8:32pm by Maria De Bruyn

Maria De Bruyn
4,635 Points
2 Answers
Nicholas Gentile
2,930 Points
I don't understand what I'm missing here.

Posted June 29, 2015 4:52pm by Nicholas Gentile

Nicholas Gentile
2,930 Points
0 Answers
Leigh Maher
21,830 Points
Can't get it to create genre_id in the movies table?

Posted June 26, 2015 11:34am by Leigh Maher

Leigh Maher
21,830 Points
1 Answer
Richard Humulock
7,477 Points
Whats wrong with this response??

Posted June 24, 2015 7:46pm by Richard Humulock

Richard Humulock
7,477 Points
1 Answer
Alan Guevara
7,247 Points
Why do we have to add a constraint when adding a FOREIGN KEY but not when adding a PRIMARY KEY?

Posted June 24, 2015 6:36pm by Alan Guevara

Alan Guevara
7,247 Points
1 Answer
MUZ140610 Tinashe Marunda
7,028 Points
Like before, bring back the movie 'title' and genre 'name' but use the correct OUTER JOIN to bring back all movies, rega

Posted June 17, 2015 8:34pm by MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda
7,028 Points
1 Answer
William J. Terrell
17,403 Points
Database Foundations - Keys and Auto-Incrementing Values - Code Challenge Part I - [SOLVED]

Posted June 16, 2015 8:16pm by William J. Terrell

William J. Terrell
17,403 Points
1 Answer
Stefan Hoffmann
24,811 Points
title first and genre name second, database foundations

Posted June 13, 2015 8:04am by Stefan Hoffmann

Stefan Hoffmann
24,811 Points
1 Answer
MUZ140599 Rachael Tsaurai
5,406 Points
where am l missing it fom my code

Posted June 10, 2015 1:35pm by MUZ140599 Rachael Tsaurai

MUZ140599 Rachael Tsaurai
5,406 Points
0 Answers
PLUS

Michael Smith
Courses Plus Student 4,916 Points
Question about the Statement.

Posted June 9, 2015 6:04am by Michael Smith

Michael Smith
Courses Plus Student 4,916 Points
2 Answers
PLUS

James Lambert
Courses Plus Student 14,477 Points
code challenge won't accept my mysql code

Posted May 25, 2015 2:21pm by James Lambert

James Lambert
Courses Plus Student 14,477 Points
2 Answers
Henry Fleisher
460 Points
Why Is PRIMARY KEY pk_id missing?

Posted May 24, 2015 5:33pm by Henry Fleisher

Henry Fleisher
460 Points
0 Answers
Becca Ades
4,205 Points
I'm unclear as to why my code isn't working for joining inner tables!

Posted May 22, 2015 4:03pm by Becca Ades

Becca Ades
4,205 Points
1 Answer
Mark Prather
16,454 Points
Joining tables. Not sure where my code is screwing up.

Posted May 21, 2015 5:55pm by Mark Prather

Mark Prather
16,454 Points
0 Answers
Binu Alexander
4,081 Points
Stuck at the alter table statement

Posted May 12, 2015 8:25am by Binu Alexander

Binu Alexander
4,081 Points
2 Answers
Emanuel Ramirez
2,545 Points
I keep getting the same fk_genre_id missing error

Posted May 8, 2015 6:58pm by Emanuel Ramirez

Emanuel Ramirez
2,545 Points
0 Answers
ahmed saleh
2,754 Points
still cant understand what the point from linking tables?

Posted April 19, 2015 1:02am by ahmed saleh

ahmed saleh
2,754 Points
1 Answer
Alice Wein
218 Points
Joining multiple SQL tables

Posted April 9, 2015 3:46pm by Alice Wein

Alice Wein
218 Points
2 Answers
Diego Salazar
2,206 Points
What's the difference between using WHERE and ON in a Select?

Posted March 22, 2015 6:01pm by Diego Salazar

Diego Salazar
2,206 Points
2 Answers
rigzin norboo
11,059 Points
Create a genres table called "t_genres" with an auto incrementing primary key called "pk_id" and a unique column .......

Posted February 1, 2015 7:55am by rigzin norboo

rigzin norboo
11,059 Points
2 Answers
Joe Ainsworth
13,588 Points
Schema design to avoid using AS syntax

Posted January 19, 2015 4:49pm by Joe Ainsworth

Joe Ainsworth
13,588 Points
0 Answers
Phil Ward
4,204 Points
Where can i get a completed project file for this Database deep dive?

Posted December 30, 2014 3:13pm by Phil Ward

Phil Ward
4,204 Points
1 Answer

Prev Page 2 of 3 Next

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