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

Jeff Styles
2,784 Points
Is there a shorter way to write a condition such as "where id = 8 or id = 9 or id = 16"?

Posted January 25, 2017 7:38pm by Jeff Styles

Jeff Styles
2,784 Points
1 Answer
Miguel Nunez
3,266 Points
Help! Foreign Keys!

Posted November 26, 2016 6:14am by Miguel Nunez

Miguel Nunez
3,266 Points
1 Answer
Miguel Nunez
3,266 Points
Can you have a primary key and a unique key in the same table in MySQL?

Posted November 24, 2016 8:52am by Miguel Nunez

Miguel Nunez
3,266 Points
1 Answer
Miguel Nunez
3,266 Points
Different types of keys in each row in a MySQL table. Is it possible?

Posted November 22, 2016 4:30am by Miguel Nunez

Miguel Nunez
3,266 Points
1 Answer
Miguel Nunez
3,266 Points
How is it that you can combine Primary keys n unique keys together I thought they r different keys dat r used on 1 table

Posted November 20, 2016 10:21am by Miguel Nunez

Miguel Nunez
3,266 Points
2 Answers
PLUS

Mayur Pande
Courses Plus Student 11,711 Points
Getting error code 1005

Posted May 23, 2016 2:51pm by Mayur Pande

Mayur Pande
Courses Plus Student 11,711 Points
0 Answers
frank martinez
8,858 Points
" . . so we need to use the keyword 'REFERENCES' and then . . "

Posted January 13, 2016 10:57am by frank martinez

frank martinez
8,858 Points
1 Answer
Elena Paraschiv
9,938 Points
Unique key_ can or cannot be NULL?

Posted November 10, 2015 2:13pm by Elena Paraschiv

Elena Paraschiv
9,938 Points
1 Answer
Rogelio Valdez
6,244 Points
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

Posted October 21, 2015 7:52am by Rogelio Valdez

Rogelio Valdez
6,244 Points
1 Answer
Thanitsak Leuangsupornpong
7,490 Points
Why the column that we referencing is genre(id)? Why not just (id)

Posted October 13, 2015 3:51pm by Thanitsak Leuangsupornpong

Thanitsak Leuangsupornpong
7,490 Points
1 Answer
Álvaro Massana
14,142 Points
Challenge Task 1

Posted August 24, 2015 10:55am by Álvaro Massana

Álvaro Massana
14,142 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
Geoffrey Neal
30,301 Points
PRIMARY KEY returning null.

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

Geoffrey Neal
30,301 Points
1 Answer
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
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
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
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
Jim Withington
12,025 Points
Quiz Question #1 clarification (parentheses in MySQL)

Posted November 20, 2014 9:57pm by Jim Withington

Jim Withington
12,025 Points
1 Answer
Jason Dittmer
8,273 Points
Challenge Task 2, Missing the 'pk_id' Column

Posted October 21, 2014 12:18pm by Jason Dittmer

Jason Dittmer
8,273 Points
3 Answers
Kelvin Latif
9,955 Points
Quiz question one error.

Posted October 5, 2014 6:46am by Kelvin Latif

Kelvin Latif
9,955 Points
1 Answer
Marcia Haledjian
7,562 Points
Answer for challenge task 3

Posted September 22, 2014 6:25pm by Marcia Haledjian

Marcia Haledjian
7,562 Points
4 Answers
Rishi Shah
5,298 Points
Having trouble adding a constraint

Posted June 30, 2014 12:24am by Rishi Shah

Rishi Shah
5,298 Points
1 Answer
Wilner Charles
874 Points
I'm a little confused with the Keys and Auto-Incrementing Values part.

Posted June 8, 2014 11:13pm by Wilner Charles

Wilner Charles
874 Points
1 Answer
Josh Jacobsen
2,445 Points
Trouble w/ Challenge Task in "Keys & Auto Incrementing Values" within "Joining Relational Data Between Tables in SQL"

Posted June 2, 2014 7:21pm by Josh Jacobsen

Josh Jacobsen
2,445 Points
1 Answer
Toni Caktas
16,957 Points
3/3

Posted May 25, 2014 10:14am by Toni Caktas

Toni Caktas
16,957 Points
0 Answers
Toni Caktas
16,957 Points
1/3

Posted May 24, 2014 10:14pm by Toni Caktas

Toni Caktas
16,957 Points
0 Answers
. Ali
9,799 Points
OK THIS IS WEIRD

Posted March 15, 2014 5:58am by . Ali

. Ali
9,799 Points
1 Answer

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