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.