1
00:00:00,390 --> 00:00:01,260
Hello there.

2
00:00:01,270 --> 00:00:03,140
Welcome to this video.

3
00:00:03,150 --> 00:00:17,130
In this video we will be using the rescue will delete command to delete or remove rules from a table.

4
00:00:18,000 --> 00:00:23,300
Hello we are inside the tilt for a court editor.

5
00:00:23,550 --> 00:00:31,800
We are going to delete a rule from the destination table.

6
00:00:31,800 --> 00:00:36,600
So let's see what's inside the table at the moment so you do a Select

7
00:00:39,250 --> 00:00:40,860
Star.

8
00:00:40,860 --> 00:00:51,040
Star means bring back everything from the name of the table.

9
00:00:52,200 --> 00:00:57,110
What this is saying is bring back then this.

10
00:00:57,140 --> 00:01:03,380
This storm is everything from this table brink all the data.

11
00:01:03,690 --> 00:01:07,370
This indicates everything where you don't use the Asterix.

12
00:01:07,410 --> 00:01:11,840
You can specify the individual columns by using this.

13
00:01:11,880 --> 00:01:16,720
It will return all the columns and the rows from that table.

14
00:01:16,740 --> 00:01:22,410
So let me run this O up the wrong table.

15
00:01:22,410 --> 00:01:25,230
I want the destination

16
00:01:27,940 --> 00:01:28,440
right.

17
00:01:28,440 --> 00:01:31,860
This is a table I want execute that.

18
00:01:32,200 --> 00:01:35,320
All right so is this table has got eight rows.

19
00:01:35,400 --> 00:01:41,150
I am going to delete one of the rules of delete number 3.

20
00:01:41,460 --> 00:01:42,910
So rule number 3.

21
00:01:42,960 --> 00:01:44,620
I am going to delete.

22
00:01:44,730 --> 00:01:49,790
So to do that I need to use the key word delete.

23
00:01:49,800 --> 00:01:52,630
So you type in delete.

24
00:01:55,830 --> 00:01:59,450
Followed by the key word from.

25
00:02:00,270 --> 00:02:04,950
Followed by the name of the table.

26
00:02:07,320 --> 00:02:10,110
You need to apply it where the filter.

27
00:02:10,140 --> 00:02:17,760
If you don't use the where clause to filter the information it will delete all the records from the

28
00:02:17,760 --> 00:02:18,810
table.

29
00:02:18,810 --> 00:02:24,440
There are important easier way to filter the data or Row.

30
00:02:24,480 --> 00:02:30,170
You want to delete So the where are specified.

31
00:02:30,170 --> 00:02:36,730
I want to get rid of record number 3 so I'll see where S.T.

32
00:02:40,240 --> 00:02:42,820
gig was to Sydney.

33
00:02:50,280 --> 00:03:01,100
Saw this as a dilley's command delete from table destination where city this column was to Sydney.

34
00:03:01,230 --> 00:03:02,370
So it will all.

35
00:03:02,390 --> 00:03:04,430
Delete this record.

36
00:03:04,770 --> 00:03:09,160
So if I execute that he should delete that.

37
00:03:09,200 --> 00:03:10,680
Go run.

38
00:03:10,710 --> 00:03:12,550
See there say one row.

39
00:03:12,600 --> 00:03:17,210
Deleted one rule deleted so I can now add this date.

40
00:03:17,250 --> 00:03:23,730
I can revert it by doing a roll back but as uncertain then commit it.

41
00:03:23,910 --> 00:03:25,020
I don't want to roll it back.

42
00:03:25,020 --> 00:03:34,850
I'm happy with the delete I go comet so if I run this table now that record number 3 should be gone.

43
00:03:35,130 --> 00:03:37,080
See that record number three is gone.

44
00:03:37,080 --> 00:03:40,950
I've got one new york two three is missing.

45
00:03:41,030 --> 00:03:42,030
All right it's a record.

46
00:03:42,030 --> 00:03:44,350
Number three is no more.

47
00:03:44,580 --> 00:03:47,890
So this is how you would use a delete key.

48
00:03:47,910 --> 00:03:55,220
Delete command to delete rules or records from a database table.

49
00:03:55,230 --> 00:03:59,450
I have all the information in this video has been helpful.

50
00:03:59,520 --> 00:04:01,780
Try and play around.

51
00:04:01,830 --> 00:04:02,880
Practice.

52
00:04:03,060 --> 00:04:09,750
That's the only way you are going to get used to play around with it databases and using your school

53
00:04:09,780 --> 00:04:10,830
commands.

54
00:04:10,950 --> 00:04:13,140
So hope to see you again soon.

55
00:04:13,140 --> 00:04:14,760
Thanks for watching.

56
00:04:14,760 --> 00:04:16,120
Bye for now.

57
00:04:16,170 --> 00:04:17,400
You have a good day.

58
00:04:17,410 --> 00:04:18,850
Take care.
