Here even in this video I'm going to tell you that how you can delete some data from your database so
deleting the data is a very simple concept here.
But food things you need to focus like when you need to do it you have to take a column as a base just
like we have a number so I want to do some rule number.
So if I do like an equal number say One two three then that roll containing the rule number three will
completely deleted from data.
So for that one just copy this one past this one here.
And I'm just taking the total number but I meta and here you need to change this command into have a
simple command that these delete from data and then pass what you want to date where raw number equal
to.
So I am using a barometer So caution marking codes and now provide coma and passed a parameter that
you want to delete the lighted all number.
So he had the simple ways just passing this rule but things did not work with this one here.
Again the caution Mark and comma.
So what's actually happening is when you delete something that drooling but the complete truth will
be deleted.
So the rest of the columns data that are remaining there will also get deleted.
So for that one you need to include here rule number and everything after the roll number so I call
my.
So that all the columns with that particular rule number will be deleted.
So a code model be needed here.
Now just delete and what you want to delete say we have the rule number three four and five.
Let me just first show you what the things are available there.
So come on index and first few print and few there we have this one if I run this one here I go these
three.
So I delete say this one fourth rule number five.
So just delete and pass their five save this one run again your data delete is a whole different sorry
we do not have changed the name of this one.
So this one delete.
Run it again.
David go with that one.
Now if you view this thing
just view this so delete and run it again here.
We got three and four now five is deleted from this one and all the items are also deleted from here
no same with this one here.
If I just go feed this whole.
Come on see and come on we change this one so copy that address change this one here one more princes
and also replace this question mark with percentage is and now first at we view the items very well
there.
So David go with these three item.
So we are going to delete this one so delete divisive we don't have anything there do that is all number
to there save this one being done we get successful and now come on said save and run again we got only
one note to do.
So this is how you can delete the data from this database just this one.
So thanks for watching.
In the next video we learn that how we can update the data.