Treehouse | Community | Deleting Data With SQL

🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

New No-Code Track! 🚀start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Nyasha Mujakachi
4,176 Points
I am failing to see where I am getting it wrong here?

Posted June 21, 2018 6:50am by Nyasha Mujakachi

Nyasha Mujakachi
4,176 Points
1 Answer
Hanna Han
4,105 Points
Capital Y for years in STRFTIME function

Posted June 21, 2018 5:17am by Hanna Han

Hanna Han
4,105 Points
2 Answers
Trevor Ward
353 Points
SELECT * FROM results WHERE id = "Hessle" and away_score > 18; Bummer: Did you select from the 'results' table?

Posted June 21, 2018 1:58am by Trevor Ward

Trevor Ward
353 Points
1 Answer
joshua inyang
948 Points
I've tried running it in the playground but I'm not seeing my error

Posted June 20, 2018 10:28pm by joshua inyang

joshua inyang
948 Points
1 Answer
PLUS

Peter Chukwukelu
Courses Plus Student 833 Points
Hello please help me with the syntax for creating this table "Rocks" in this challenge.

Posted June 19, 2018 6:56pm by Peter Chukwukelu

Peter Chukwukelu
Courses Plus Student 833 Points
1 Answer
joshua inyang
948 Points
Hello I'm a not understanding this can someone assist I thought this was saying to concatenate first, last, email?

Posted June 19, 2018 4:58pm by joshua inyang

joshua inyang
948 Points
3 Answers
rh16
3,781 Points
INSERT INTO CONCERTS VALUES (10, ‘2018-03-22’, ‘Vancouver’, ‘BC’, ‘BC Place’, ‘Canada’); produces error

Posted June 19, 2018 2:15am by rh16

rh16
3,781 Points
- Databases
1 Answer
joshua inyang
948 Points
AutoCommit and Transactions

Posted June 18, 2018 9:28pm by joshua inyang

joshua inyang
948 Points
2 Answers
Deborah Watson
2,614 Points
Count function

Posted June 18, 2018 9:14pm by Deborah Watson

Deborah Watson
2,614 Points
1 Answer
Christopher Parke
21,978 Points
No error, but error?

Posted June 18, 2018 5:04pm by Christopher Parke

Christopher Parke
21,978 Points
3 Answers
Christopher Parke
21,978 Points
error messages are useless

Posted June 18, 2018 4:31pm by Christopher Parke

Christopher Parke
21,978 Points
1 Answer
Killeon Patterson
18,528 Points
MongoDB Connection Error

Posted June 18, 2018 2:36pm by Killeon Patterson

Killeon Patterson
18,528 Points
- Databases
2 Answers
rh16
3,781 Points
why am I getting "Error: foreign key mismatch - "TICKETS" referencing "CONCERTS" when creating TICKETS table ?

Posted June 17, 2018 11:27pm by rh16

rh16
3,781 Points
- Databases
3 Answers
Susan Thatcher
1,217 Points
My code: SELECT username FROM user WHERE last_name= "Chalkley"; It's not working.

Posted June 17, 2018 10:13pm by Susan Thatcher

Susan Thatcher
1,217 Points
2 Answers
PLUS

Peter Chukwukelu
Courses Plus Student 833 Points
SELECT md.ModelName, ca.VIN, ca.StickerPrice FROM Model AS md INNER JOIN car AS ca ON md.ModelID, md.MakeID = ca.CarID;

Posted June 17, 2018 6:09pm by Peter Chukwukelu

Peter Chukwukelu
Courses Plus Student 833 Points
1 Answer
Joe Keogh
892 Points
Display information about store item [Php & SQL]

Posted June 16, 2018 4:55pm by Joe Keogh

Joe Keogh
892 Points
- Databases
2 Answers
Odane Williams
6,692 Points
I followed all the examples but I'm getting an error that says the query is not returning through A and K.

Posted June 15, 2018 6:28pm by Odane Williams

Odane Williams
6,692 Points
1 Answer
Zach Bucek
10,798 Points
Deprecated setup method?

Posted June 15, 2018 5:10pm by Zach Bucek

Zach Bucek
10,798 Points
5 Answers
barak ben ishay
1,951 Points
how to replace

Posted June 15, 2018 1:10pm by barak ben ishay

barak ben ishay
1,951 Points
3 Answers
barak ben ishay
1,951 Points
COUNTING RESULATS

Posted June 15, 2018 11:04am by barak ben ishay

barak ben ishay
1,951 Points
4 Answers
Michael Martin
8,653 Points
What is wrong here? I don't understand the output matches against itself

Posted June 15, 2018 4:13am by Michael Martin

Michael Martin
8,653 Points
2 Answers
adam woolf
1,181 Points
i do not understand when it says there are only 3 entries in this syntax for entering a new product.

Posted June 15, 2018 12:19am by adam woolf

adam woolf
1,181 Points
1 Answer
Jonathan Whittle
28,309 Points
Limiting Results by First Letter of Name

Posted June 14, 2018 10:43pm by Jonathan Whittle

Jonathan Whittle
28,309 Points
1 Answer
Patty Johnson
26,560 Points
Create an alphabetical list of produce that is considered both a fruit and a vegetable.

Posted June 14, 2018 9:04pm by Patty Johnson

Patty Johnson
26,560 Points
1 Answer
Hanna Han
4,105 Points
Replace usage

Posted June 13, 2018 3:24pm by Hanna Han

Hanna Han
4,105 Points
2 Answers
Devesh Singh
5,267 Points
Not sure about how to create the query

Posted June 13, 2018 2:52pm by Devesh Singh

Devesh Singh
5,267 Points
1 Answer
Hanna Han
4,105 Points
Does length count in white space in syntax?

Posted June 13, 2018 12:28pm by Hanna Han

Hanna Han
4,105 Points
1 Answer
Hanna Han
4,105 Points
quotes usage for column names when using AS keyword

Posted June 13, 2018 10:21am by Hanna Han

Hanna Han
4,105 Points
1 Answer
Lisa Simpson
33,351 Points
Concatination

Posted June 12, 2018 10:05am by Lisa Simpson

Lisa Simpson
33,351 Points
1 Answer
Michael Martin
8,653 Points
What is wrong with my syntax?

Posted June 12, 2018 3:43am by Michael Martin

Michael Martin
8,653 Points
1 Answer

Prev Page 40 of 389 Next

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