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

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
Greg Wollf
12,463 Points
Unable to start MySQL server

Posted August 10, 2015 8:08pm by Greg Wollf

Greg Wollf
12,463 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
Mateen Mukadam
268 Points
How do I get the server administration as shown in the video, after installing everything from MySQL installer 5.6.10?

Posted August 10, 2015 2:59pm by Mateen Mukadam

Mateen Mukadam
268 Points
0 Answers
Gleb Sklyr
17,492 Points
problem with mysql server

Posted August 10, 2015 1:30am by Gleb Sklyr

Gleb Sklyr
17,492 Points
2 Answers
Ricardo Vargas
3,583 Points
Using functions better practices question

Posted August 8, 2015 7:58pm by Ricardo Vargas

Ricardo Vargas
3,583 Points
1 Answer
Daniel Sibanda
4,803 Points
Select the first letter of the "first_name", add a period after it, followed by a space and add the "last_name". Also, c

Posted August 6, 2015 11:05am by Daniel Sibanda

Daniel Sibanda
4,803 Points
2 Answers
Daniel Sibanda
4,803 Points
Select the "first_name" followed by the username in parentheses and alias it as "display_name". For example "Andrew (cha

Posted August 6, 2015 9:54am by Daniel Sibanda

Daniel Sibanda
4,803 Points
1 Answer
Brian Baker
471 Points
Select all movies from between the years 1999 to 2004

Posted August 4, 2015 4:41am by Brian Baker

Brian Baker
471 Points
1 Answer
Christian Espinoza
4,163 Points
Can someone PLEASE help me get past this "step"??

Posted August 4, 2015 4:16am by Christian Espinoza

Christian Espinoza
4,163 Points
1 Answer
Zy Mazza
3,327 Points
Please help - connection problem

Posted August 4, 2015 2:08am by Zy Mazza

Zy Mazza
3,327 Points
1 Answer
Brian Baker
471 Points
What is the proper syntax for challenge task 1 of 2

Posted August 3, 2015 9:49pm by Brian Baker

Brian Baker
471 Points
1 Answer
Eric Lin
5,541 Points
Installation process of mysql

Posted July 31, 2015 7:47am by Eric Lin

Eric Lin
5,541 Points
2 Answers
Hector Urbina
6,064 Points
I can’t start my MySQL Server.

Posted July 30, 2015 5:14pm by Hector Urbina

Hector Urbina
6,064 Points
2 Answers
Echo Yang
6,740 Points
About package mysql.dmg and mysql in terminal

Posted July 29, 2015 4:22pm by Echo Yang

Echo Yang
6,740 Points
0 Answers
Rajiv Barton
12,051 Points
Install via Bitnami

Posted July 29, 2015 3:21pm by Rajiv Barton

Rajiv Barton
12,051 Points
0 Answers
MUZ141094 Smart Mashegede
3,335 Points
"Group all reviews by "movie_id" and get the average "score" and alias it as "average"

Posted July 29, 2015 12:42pm by MUZ141094 Smart Mashegede

MUZ141094 Smart Mashegede
3,335 Points
3 Answers
Karol Bekieszczuk
3,340 Points
after loading a script 'mysql workbench stopped working' great!

Posted July 29, 2015 9:56am by Karol Bekieszczuk

Karol Bekieszczuk
3,340 Points
0 Answers
MUZ140886 Mandava
4,675 Points
task 1 no longer passing

Posted July 29, 2015 8:23am by MUZ140886 Mandava

MUZ140886 Mandava
4,675 Points
1 Answer
MUZ140886 Mandava
4,675 Points
i want the badge

Posted July 29, 2015 7:53am by MUZ140886 Mandava

MUZ140886 Mandava
4,675 Points
1 Answer
samilan
408 Points
ORDER BY year and ORDER BY year ASC

Posted July 28, 2015 11:23pm by samilan

samilan
408 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
Nathan P
1,686 Points
Password Issue with Terminal when installing MySQL Workbench config file

Posted July 28, 2015 5:32am by Nathan P

Nathan P
1,686 Points
0 Answers
Junichi Shibatani
651 Points
CONCAT question

Posted July 27, 2015 8:38pm by Junichi Shibatani

Junichi Shibatani
651 Points
1 Answer
Daniel Sibanda
4,803 Points
Oops! It looks like Task 1 is no longer passing.

Posted July 27, 2015 8:53am by Daniel Sibanda

Daniel Sibanda
4,803 Points
1 Answer
samilan
408 Points
Select all movies from the year 2003. my answer is: SELECT * FROM movies WHERE year >= 2003; why it's wrong?

Posted July 26, 2015 11:59pm by samilan

samilan
408 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
Alexander Schott
8,318 Points
How to connect to mySql-database on webhostingforstudents server

Posted July 26, 2015 10:52am by Alexander Schott

Alexander Schott
8,318 Points
0 Answers
Karolis Strazdas
1,276 Points
SQL Error

Posted July 25, 2015 5:55pm by Karolis Strazdas

Karolis Strazdas
1,276 Points
1 Answer
MUZ140886 Mandava
4,675 Points
JUST CANT PASS

Posted July 24, 2015 10:34am by MUZ140886 Mandava

MUZ140886 Mandava
4,675 Points
0 Answers

Prev Page 7 of 19 Next

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