Treehouse | Community | Inserting Data

🤑 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

MUZ140610 Tinashe Marunda
7,028 Points
In the "actors" table INSERT a new actor with the name "Michael J. Fox". this answer is refusing and i dont know why

Posted June 3, 2015 2:04pm by MUZ140610 Tinashe Marunda

MUZ140610 Tinashe Marunda
7,028 Points
1 Answer
William J. Terrell
17,403 Points
Question Regarding MySQL's Website and the Product Itself

Posted June 2, 2015 4:13pm by William J. Terrell

William J. Terrell
17,403 Points
1 Answer
sayedshahidi
9,158 Points
Why use if not exists ?

Posted May 31, 2015 2:16pm by sayedshahidi

sayedshahidi
9,158 Points
2 Answers
Stephen Moss
2,285 Points
I've read the documentation and checked against my database and the query is correct, but reporting wrong in the quiz.

Posted May 31, 2015 2:31am by Stephen Moss

Stephen Moss
2,285 Points
2 Answers
Juliette Tworsey
Front End Web Development Techdegree Graduate 32,425 Points
Select the first letter of the "first_name", add a period after it, followed by a space and add the "last_name".

Posted May 29, 2015 7:18pm by Juliette Tworsey

Juliette Tworsey
Front End Web Development Techdegree Graduate 32,425 Points
0 Answers
Samuel Sanders
6,992 Points
MySQL Workbench opens, but I get a "NO CONNECTION" to Name: Local instance MySQL Host: 3306 Port: 3306

Posted May 28, 2015 9:06pm by Samuel Sanders

Samuel Sanders
6,992 Points
0 Answers
dotz
6,733 Points
numeric and aggregate functions challenge 3

Posted May 28, 2015 9:00pm by dotz

dotz
6,733 Points
1 Answer
Juliette Tworsey
Front End Web Development Techdegree Graduate 32,425 Points
Like before, group reviews by "movie_id", get the average "score" as "average" and only include averages under 2.

Posted May 28, 2015 8:35pm by Juliette Tworsey

Juliette Tworsey
Front End Web Development Techdegree Graduate 32,425 Points
2 Answers
Arjun Temurnikar
9,695 Points
I can't figure this out!

Posted May 28, 2015 11:50am by Arjun Temurnikar

Arjun Temurnikar
9,695 Points
2 Answers
Jami Schwarzwalder
17,961 Points
There is something wrong with your query. Challenge Task 3 of 3

Posted May 26, 2015 2:25am by Jami Schwarzwalder

Jami Schwarzwalder
17,961 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
dotz
6,733 Points
LIMITING

Posted May 25, 2015 1:53am by dotz

dotz
6,733 Points
1 Answer
David Axelrod
36,073 Points
Creating a database code challenge, task#1

Posted May 24, 2015 10:05pm by David Axelrod

David Axelrod
36,073 Points
1 Answer
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
Henry Fleisher
460 Points
For Challenge Task 2 of 2, I wrote the following code: "SELECT * FROM movies LIMIT 12, 20." Why is it wrong?

Posted May 23, 2015 6:54pm by Henry Fleisher

Henry Fleisher
460 Points
1 Answer
PLUS

Anuj Nagpal
Courses Plus Student 3,748 Points
Getting wrong answer

Posted May 23, 2015 1:26pm by Anuj Nagpal

Anuj Nagpal
Courses Plus Student 3,748 Points
1 Answer
Becca Ades
4,205 Points
Don't understand why my code isn't working: SELECT CONCAT(first_name," ",(username)) AS display_name FROM users;

Posted May 22, 2015 10:27pm by Becca Ades

Becca Ades
4,205 Points
1 Answer
Mark Prather
16,454 Points
What's the name of the table? It never mentions which table name it wants.

Posted May 22, 2015 7:01pm by Mark Prather

Mark Prather
16,454 Points
1 Answer
Becca Ades
4,205 Points
Outer Join not working! I put the following to run my query and I'm confused as to why it's not working.

Posted May 22, 2015 6:54pm by Becca Ades

Becca Ades
4,205 Points
3 Answers
Becca Ades
4,205 Points
I'm not sure why this isn't working! I'm getting a message that there is an error with my query.

Posted May 22, 2015 5:39pm by Becca Ades

Becca Ades
4,205 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
moath alqutoob
2,450 Points
what the corect answer

Posted May 22, 2015 2:11pm by moath alqutoob

moath alqutoob
2,450 Points
1 Answer
Becca Ades
4,205 Points
I don't understand what this question is asking me to do: Select all movies with the "year" column that hasn't been popu

Posted May 21, 2015 7:24pm by Becca Ades

Becca Ades
4,205 Points
2 Answers
Becca Ades
4,205 Points
I'm putting the following answer "SELECT * FROM actors LIMIT 1. 100;" and I'm getting an error message. Help!

Posted May 21, 2015 7:16pm by Becca Ades

Becca Ades
4,205 Points
2 Answers
Becca Ades
4,205 Points
I'm writing SELECT actors.name FROM movies; and it's not working and I'm not sure why!

Posted May 21, 2015 6:27pm by Becca Ades

Becca Ades
4,205 Points
1 Answer
joleneoropilla
17,214 Points
What is the difference in syntax in Task 3 of 3 in the Grouping, Joining and Cleaning Up?

Posted May 21, 2015 6:04pm by joleneoropilla

joleneoropilla
17,214 Points
0 Answers
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
Sidney Eubanks
3,864 Points
This video needs to be updated

Posted May 21, 2015 5:15am by Sidney Eubanks

Sidney Eubanks
3,864 Points
0 Answers
PLUS

Saira Bottemuller
Courses Plus Student 1,749 Points
SQL Challenge: Grouping, Joining, & Cleaning Up

Posted May 20, 2015 9:41pm by Saira Bottemuller

Saira Bottemuller
Courses Plus Student 1,749 Points
2 Answers
Walter Bueso
10,654 Points
What to download if I already have XAMPP?

Posted May 19, 2015 12:24am by Walter Bueso

Walter Bueso
10,654 Points
1 Answer

Prev Page 11 of 19 Next

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