SQL Tutorial - 22: The DELETE Query Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the twenty second tutorial in this
course and in this tutorial we will be
checking out the delete query in SQL and
we're going to first see what the delete
body is used for so as you can see the
delete query is used to the lead or
remove rows or records from a table in
your database and you know we checked
out the update query in the last
tutorial when I told you guys that in
most cases you use the update query with
the where clause and you know just like
update you use the delete query with the
weight loss to in most cases unless of
course you want to remove all rows or
records from your table right and the
syntax of the delete query is pretty
simple you have just one keyword one new
keyword and that is delete right and you
put in that not that you put in the
keyword from and then you specify the
name of your table and then in case you
want to put in your where condition you
put in that but that's optional so you
know it's not something that you have to
put in your query let's check out an
example in the MySQL environment to you
know get a better grip of thing so I've
got my workbench and what I'm going to
do is I'm going to quickly execute the
select star from employee query and have
a look at the data that I have in the
table so I've got quite a lot of rows
and you see that you know the row with
ID 1917 is for the employee
Roger whose age is 27 and
email address field and the salary
fields both the fields also have some
values so what if I want to remove this
row completely from the table right not
just the ID value of course you know the
row cannot exist with the ID without the
ID value because the ID field is the
primary key but let's say I want to
remove the row completely from the table
I don't want to see the row with ID 1917
in the table right so how do I do that I
have to use the delete quite to do it
right and let's see how the delete way
is going to look like so I'll type in
the keyword delete and then the keyword
from then the name of the table which is
employee and then on the next line I'll
specify you know the condition using the
where clause and the condition here is
important because if I won't specify it
then all the rows from the table would
be deleted right and since I just want
the row with ID 1917 to be removed from
the table and have to specify that so
the column on which we will be operating
is the ID column and the value would be
1917 right and put in the semicolon when
I press control enter I see that I don't
get any result set but in the output
section I get the message that the Ricoh
has been successfully executed so now if
I execute the Select star statement I
see that in the result set the ID with
1917 the row with ID 1917 is is not
present in the result set right so it
has been removed so that's about the
delete state another way of removing
rows if you you know just want to
understand the GUI way of doing things
you want to get things done quickly is
that you know you go to a record and you
you know select it first you have to
select the record right and then you
right click and you select delete rows
from the menu that you get and when you
close your result set you're asked you
know whether you want to apply changes
or not if you click on apply then you
know the window shows the query that
would have to be executed to make the
changes that you
made and then if you click on apply' you
know it tells you that the statements
have been executed and then when you
click on finish your jobs done so now if
I would execute the Select star
statement I would see that the row with
ie D 1916 is also missing right so
that's about the read statement I hope
you guys enjoyed the tutorial thank you
so much for watching and please
subscribe to my channel in case you have
already assumed the next one which will
discuss something interesting and
important for sure and take care