Treehouse | Community | Removing Data from All Rows in a Table

💥 2026 New Year's Sale 💥 Take 50% off your first 6 months! (new subscribers only, renews at regular price).

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

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Angelus Miculek
6,979 Points
no asterisk

Posted November 6, 2024 4:46pm by Angelus Miculek

Angelus Miculek
6,979 Points
2 Answers
Nile Rankin-Watson
1,780 Points
What's wrong with this code? SELECT first_name || " " || last_name || " <" || email || ">" AS "to_field";

Posted June 18, 2024 8:28pm by Nile Rankin-Watson

Nile Rankin-Watson
1,780 Points
1 Answer
Abigail Solomon
4,716 Points
How do you alias the strings you concatenate to "to_field"? And properly concatenate these strings?

Posted May 10, 2024 8:33pm by Abigail Solomon

Abigail Solomon
4,716 Points
2 Answers
Nameer Jamal
309 Points
Now, in the MEMBERS table, we'd like to change the FAVORITE_ROCK column to be FAVORITE_ROCK_ID, and it should be a forei

Posted December 11, 2023 9:21am by Nameer Jamal

Nameer Jamal
309 Points
1 Answer
Rojina Pradhan
2,681 Points
Find all the matches in the results table where "Hessle" was playing away as the away team and if they played on or afte

Posted October 3, 2023 2:19pm by Rojina Pradhan

Rojina Pradhan
2,681 Points
2 Answers
Rosina Marchan
3,011 Points
There are two tables Fruit and Vegetable table. The Fruit table has a FruitID and a Name column and the Vegetable table

Posted September 7, 2023 6:58pm by Rosina Marchan

Rosina Marchan
3,011 Points
1 Answer
Jason Chalangary
11,695 Points
What is wrong with my code?

Posted August 15, 2023 1:21pm by Jason Chalangary

Jason Chalangary
11,695 Points
2 Answers
Jace Vanwagoner
6,767 Points
How can I save the SQL Playground practice's to be able to add them to a portfolio???

Posted May 24, 2023 3:14pm by Jace Vanwagoner

Jace Vanwagoner
6,767 Points
1 Answer
PLUS

zaal rottunda
Courses Plus Student 2,434 Points
SQL Error: no such column: VIN

Posted May 3, 2023 8:46pm by zaal rottunda

zaal rottunda
Courses Plus Student 2,434 Points
1 Answer
Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
Import Table in my VS code

Posted January 13, 2023 1:33pm by Gabriel Guerra

Gabriel Guerra
Data Analysis Techdegree Graduate 9,109 Points
2 Answers
Erik L
Full Stack JavaScript Techdegree Graduate 19,470 Points
at 3:50 the video kind of starts to glitch...

Posted January 30, 2019 5:07am by Erik L

Erik L
Full Stack JavaScript Techdegree Graduate 19,470 Points
2 Answers
Adam Tatusko
16,589 Points
MySQL Pronunciation

Posted March 27, 2018 2:00pm by Adam Tatusko

Adam Tatusko
16,589 Points
2 Answers
PLUS

MANDEEP SINGH
Courses Plus Student 935 Points
STRFTIME function is not returning correct answer.

Posted May 3, 2017 2:14am by MANDEEP SINGH

MANDEEP SINGH
Courses Plus Student 935 Points
- Databases
3 Answers
pujaagarwal2
1,213 Points
SOLVED

Posted May 18, 2016 12:44am by pujaagarwal2

pujaagarwal2
1,213 Points
- Databases
4 Answers
Javier Alvarado
16,060 Points
Are SQL table names always lower case?

Posted May 7, 2016 10:28pm by Javier Alvarado

Javier Alvarado
16,060 Points
5 Answers
Pablo Caro
4,191 Points
having issue with this query. Where clause is in the query

Posted January 24, 2016 3:15am by Pablo Caro

Pablo Caro
4,191 Points
- Databases
1 Answer
Aden Ziguang Wang
1,307 Points
In the SQL Playground - Stage 3: Practice Question: Movies with any Missing Data

Posted January 22, 2016 9:17pm by Aden Ziguang Wang

Aden Ziguang Wang
1,307 Points
3 Answers
A X
12,842 Points
Discovered bug in Filtering by comparing columns Challenge Task

Posted January 17, 2016 10:08pm by A X

A X
12,842 Points
2 Answers
Adiv Abramson
6,919 Points
My query has an OUTER JOIN but the editor complains that it doesn't.

Posted January 12, 2016 2:48pm by Adiv Abramson

Adiv Abramson
6,919 Points
- Databases
2 Answers
Adiv Abramson
6,919 Points
My query returned results but I got a warning that something's wrong with my query

Posted January 12, 2016 1:37pm by Adiv Abramson

Adiv Abramson
6,919 Points
- Databases
4 Answers
PLUS

Khalil Al-Rashid
Courses Plus Student 933 Points
Exporting database table into html webpage?

Posted January 11, 2016 7:11pm by Khalil Al-Rashid

Khalil Al-Rashid
Courses Plus Student 933 Points
- Databases
2 Answers
PLUS

Khalil Al-Rashid
Courses Plus Student 933 Points
Creating Dynamic Website

Posted January 11, 2016 6:42pm by Khalil Al-Rashid

Khalil Al-Rashid
Courses Plus Student 933 Points
- Databases
2 Answers
George Akinian
17,615 Points
Not able to rename with db.rename()

Posted January 10, 2016 12:25am by George Akinian

George Akinian
17,615 Points
2 Answers
Jesse Bartola
10,438 Points
Unable to install Mongo-Hacker

Posted December 31, 2015 8:31pm by Jesse Bartola

Jesse Bartola
10,438 Points
8 Answers
PLUS

andrew luu
Courses Plus Student 1,000 Points
I need a hint

Posted December 27, 2015 8:41am by andrew luu

andrew luu
Courses Plus Student 1,000 Points
- Databases
1 Answer
Leo Lanahan
22,018 Points
Searching within a set of values 1 of 2

Posted December 27, 2015 3:33am by Leo Lanahan

Leo Lanahan
22,018 Points
- Databases
2 Answers
Dominik Singer
3,528 Points
What am i doing wrong?

Posted December 25, 2015 6:36pm by Dominik Singer

Dominik Singer
3,528 Points
- Databases
1 Answer
PLUS

Ary de Oliveira
Courses Plus Student 28,304 Points
SQL BASIC

Posted December 20, 2015 7:15pm by Ary de Oliveira

Ary de Oliveira
Courses Plus Student 28,304 Points
- Databases
9 Answers
PLUS

Tony K
Courses Plus Student 442 Points
Cannot Update row in MySQL !

Posted December 3, 2015 6:43pm by Tony K

Tony K
Courses Plus Student 442 Points
- Databases
4 Answers

Prev Page 189 of 389 Next

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