Treehouse | Community | Joining Tables and Aliasing

🤑 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

Alex Flores
7,864 Points
There has to be an easier way to update tables?

Posted February 22, 2017 9:31pm by Alex Flores

Alex Flores
7,864 Points
1 Answer
Alex Flores
7,864 Points
Should I create many different tables and join or fewer tables?

Posted February 22, 2017 4:22am by Alex Flores

Alex Flores
7,864 Points
1 Answer
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
A X
12,842 Points
We're told to take the load off the Database w/ Normalization: But how is Normalizing less "Load Intensive"?

Posted April 2, 2016 9:32pm by A X

A X
12,842 Points
2 Answers
Travis Smith
476 Points
LEFT OUTER JOIN Why would you want to do a LEFT OUTER JOIN versus just returning all of the data in the "Left" column?

Posted March 16, 2016 11:20pm by Travis Smith

Travis Smith
476 Points
1 Answer
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
Adiv Abramson
6,919 Points
Why use an alias for genres.name? Isn't using a keyword as a column name bad practice?

Posted October 12, 2015 3:25pm by Adiv Abramson

Adiv Abramson
6,919 Points
1 Answer
Alex Martino
367 Points
First Question of Inner Join...I don't understand.

Posted September 30, 2015 7:49am by Alex Martino

Alex Martino
367 Points
1 Answer
Alex Martino
367 Points
Help with inner join

Posted September 30, 2015 2:29am by Alex Martino

Alex Martino
367 Points
0 Answers
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
Joining 2 tables ...

Posted September 24, 2015 12:05pm by Bularca Andrei

Bularca Andrei
2,408 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
INNER JOIN

Posted September 22, 2015 5:26am by Angelos Bolovinos

Angelos Bolovinos
3,958 Points
2 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
Álvaro Massana
14,142 Points
Challenge Task 1

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

Álvaro Massana
14,142 Points
2 Answers
Michael King
874 Points
Forgot to add genres_id column

Posted August 16, 2015 1:24pm by Michael King

Michael King
874 Points
1 Answer
jimmy bryant
3,747 Points
Are these SQL statements or MySQL statements?

Posted August 12, 2015 4:04pm by jimmy bryant

jimmy bryant
3,747 Points
1 Answer

Prev Page 1 of 3 Next

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