Treehouse | Community | Keys and Auto-Incrementing Values

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 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

Alex Martino
367 Points
Problem with primary key

Posted September 27, 2015 7:53pm by Alex Martino

Alex Martino
367 Points
2 Answers
Bularca Andrei
2,408 Points
This is sad :(

Posted September 24, 2015 11:14am by Bularca Andrei

Bularca Andrei
2,408 Points
1 Answer
Matthew Flewelling
5,221 Points
Not sure what I'm missing

Posted September 22, 2015 5:23pm by Matthew Flewelling

Matthew Flewelling
5,221 Points
0 Answers
Angelos Bolovinos
3,958 Points
ALTER TABLE FOREIGN KEY

Posted September 21, 2015 6:12am by Angelos Bolovinos

Angelos Bolovinos
3,958 Points
2 Answers
Ryan Quinn
2,027 Points
Creating Primary and Unique Keys

Posted September 19, 2015 5:47pm by Ryan Quinn

Ryan Quinn
2,027 Points
3 Answers
gilroncharles
8,978 Points
My answer doesn't pass. I've copied the command into mysql workbench and the table is created with no issues;

Posted September 16, 2015 2:08am by gilroncharles

gilroncharles
8,978 Points
2 Answers
Danielle Schertz
483 Points
Stuck on Challenge question

Posted September 3, 2015 7:29pm by Danielle Schertz

Danielle Schertz
483 Points
2 Answers
Asif Ahmed
8,980 Points
This command isn't working even though it works in MySQLWORKBENCH

Posted August 28, 2015 1:49am by Asif Ahmed

Asif Ahmed
8,980 Points
1 Answer
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
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
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
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
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
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
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

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