SQL DELETE Query |¦| SQL Delete Command |¦| SQL Tutorial

In SQL, the DELETE query is used to delete a row from a table. In this tutorial we will show you how to use the delete command to remove one or more rows from a table. The key is to carefully test your query and make sure your WHERE clause targets exactly those desired rows.

To do this, we will first write the DELETE query, comment it out using one of the two ways to write a comment in SQL, test the WHERE with a SELECT, then finally execute the DELETE.

The song data used in this tutorial can be downloaded from Github:

Our SQL playlist starts here:

Be sure to SUBSCRIBE for more SQL!

You may also enjoy our Python playlist:

♦♦♦♦♦♦♦♦♦♦

Ways to support our channel:

►  We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9

Thank you!

♦♦♦♦♦♦♦♦♦♦

Connect with us!

♦♦♦♦♦♦♦♦♦♦

♦♦♦♦♦♦♦♦♦♦

[Socratica]

It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉

[justinhonse]

FYI this video is excellent for anyone who works in QA and needs to learn to use SQL. The small queries that she calls sanity checks are critical, basically you need to look at what the current state is, and then determining what is reasonable, what is complete or incomplete etc., you then change your query accordingly and then double check your results after the changes. You may not be using any delete queries yourself, but this is still good to understand the process since you’ll likely need to interact with developers on some level.

[chidimoses]

No youtube presentation has blown me off like yours, the narration kept me glued to the screen and its quite very educational. Good work.

[JianqiuChen]

This is important enough to say in French "Ceci va effacer toutes vos lignes!", omg, she is a legend!

[e-k]

The only channel that I closed my ad-blocker while watching.

[gamestv]

To the point, no bullshit tutorials.
Love the voice of this woman.
Subbed.

[virtus]

Who else is watching this just for the jokes part?

[PlusHD]

How the heck I didn't know about this channel until now?

[CapitalCH]

thank you for making this interesting and easy to follow along. i wish school was more like this!

[thevoid]

Never experienced such learning before, worth an experience, this is one of the channel that i loved the most...

[elnazdehkharghani]

First, you need to create your database after that create your table with this query : (you can find query page from Tools -> Query Tool)



(
song_id serial primary key,
title character varying,
artist character varying,
album character varying,
year_released integer,
duration numeric,
tempo numeric,
loudness numeric
)

Then Import data in your table... How? First, save data from Github and add it into one of your computer paths then right-click on your table and choose Import/Export data - from filename import your CSV file, be sure to turn on IMPORT and HEADER - DONE!

[polymerus_]

Congrats from Argentina ! Yours videos are awesome !

[FrX_XIII_]

thx for "ceci va effacer toutes vos lignes" ^^

[schemage]

I wonder if that serious face ought to be destroyed? I mean it ain't very serious. :)

Great video as always, Socratica makes SQL awesome!! Would love to see how one might implement some of this SQL with python at some stage.

[steveoshaughnessy]

Deleting is dangerous. I do the select first too. But instead of then deleting the SELECT and running a separate DELETE, I comment out the SELECT line and add a DELETE. In other words, use the exact same WHERE clause. That way there's no typeo moving from one to the other.

[Phoenixspin]

Crying over the deleted songs. I'm devastated.

[WaldoTheWombat]

I successfully imported the CSV according the PGAdmin, but the table is empty. can someone help?

[robertkramer]

I have a new answer for who I would say when people ask if I could have dinner with anyone living or dead. She is too funny! and informative!

[kirbymarchbarcena]

What I fear is accidentally deleting my subscription to this channel without knowing it.

[woolfel]

suggestion for you. discuss logical delete and strategies for implementing it. In many business sectors like finance and insurance, data retention laws requires the business keep the data around for a minimum amount of time. Then a follow up to that is how do you manage the data, so that performance doesn't go down the tubes. Why many large companies have transactional databases and data warehouse.