Hello there.
Welcome to this video.
In this video we will be using the rescue will delete command to delete or remove rules from a table.
Hello we are inside the tilt for a court editor.
We are going to delete a rule from the destination table.
So let's see what's inside the table at the moment so you do a Select
Star.
Star means bring back everything from the name of the table.
What this is saying is bring back then this.
This storm is everything from this table brink all the data.
This indicates everything where you don't use the Asterix.
You can specify the individual columns by using this.
It will return all the columns and the rows from that table.
So let me run this O up the wrong table.
I want the destination
right.
This is a table I want execute that.
All right so is this table has got eight rows.
I am going to delete one of the rules of delete number 3.
So rule number 3.
I am going to delete.
So to do that I need to use the key word delete.
So you type in delete.
Followed by the key word from.
Followed by the name of the table.
You need to apply it where the filter.
If you don't use the where clause to filter the information it will delete all the records from the
table.
There are important easier way to filter the data or Row.
You want to delete So the where are specified.
I want to get rid of record number 3 so I'll see where S.T.
gig was to Sydney.
Saw this as a dilley's command delete from table destination where city this column was to Sydney.
So it will all.
Delete this record.
So if I execute that he should delete that.
Go run.
See there say one row.
Deleted one rule deleted so I can now add this date.
I can revert it by doing a roll back but as uncertain then commit it.
I don't want to roll it back.
I'm happy with the delete I go comet so if I run this table now that record number 3 should be gone.
See that record number three is gone.
I've got one new york two three is missing.
All right it's a record.
Number three is no more.
So this is how you would use a delete key.
Delete command to delete rules or records from a database table.
I have all the information in this video has been helpful.
Try and play around.
Practice.
That's the only way you are going to get used to play around with it databases and using your school
commands.
So hope to see you again soon.
Thanks for watching.
Bye for now.
You have a good day.
Take care.