1 00:00:05,720 --> 00:00:11,630 Here even in this video I'm going to tell you that how you can delete some data from your database so 2 00:00:11,630 --> 00:00:14,100 deleting the data is a very simple concept here. 3 00:00:14,180 --> 00:00:20,000 But food things you need to focus like when you need to do it you have to take a column as a base just 4 00:00:20,000 --> 00:00:23,410 like we have a number so I want to do some rule number. 5 00:00:23,600 --> 00:00:29,720 So if I do like an equal number say One two three then that roll containing the rule number three will 6 00:00:29,720 --> 00:00:31,190 completely deleted from data. 7 00:00:32,360 --> 00:00:37,650 So for that one just copy this one past this one here. 8 00:00:39,190 --> 00:00:46,190 And I'm just taking the total number but I meta and here you need to change this command into have a 9 00:00:46,190 --> 00:00:56,630 simple command that these delete from data and then pass what you want to date where raw number equal 10 00:00:56,630 --> 00:00:57,080 to. 11 00:00:57,140 --> 00:01:04,520 So I am using a barometer So caution marking codes and now provide coma and passed a parameter that 12 00:01:04,520 --> 00:01:08,170 you want to delete the lighted all number. 13 00:01:08,990 --> 00:01:15,530 So he had the simple ways just passing this rule but things did not work with this one here. 14 00:01:15,710 --> 00:01:17,940 Again the caution Mark and comma. 15 00:01:17,990 --> 00:01:21,920 So what's actually happening is when you delete something that drooling but the complete truth will 16 00:01:21,920 --> 00:01:23,000 be deleted. 17 00:01:23,000 --> 00:01:28,370 So the rest of the columns data that are remaining there will also get deleted. 18 00:01:28,370 --> 00:01:35,180 So for that one you need to include here rule number and everything after the roll number so I call 19 00:01:35,180 --> 00:01:35,750 my. 20 00:01:36,050 --> 00:01:40,850 So that all the columns with that particular rule number will be deleted. 21 00:01:40,850 --> 00:01:43,700 So a code model be needed here. 22 00:01:43,700 --> 00:01:50,240 Now just delete and what you want to delete say we have the rule number three four and five. 23 00:01:50,240 --> 00:01:54,230 Let me just first show you what the things are available there. 24 00:01:55,280 --> 00:02:08,700 So come on index and first few print and few there we have this one if I run this one here I go these 25 00:02:08,700 --> 00:02:09,420 three. 26 00:02:09,420 --> 00:02:15,160 So I delete say this one fourth rule number five. 27 00:02:16,140 --> 00:02:28,540 So just delete and pass their five save this one run again your data delete is a whole different sorry 28 00:02:28,550 --> 00:02:31,000 we do not have changed the name of this one. 29 00:02:31,310 --> 00:02:33,430 So this one delete. 30 00:02:34,230 --> 00:02:35,270 Run it again. 31 00:02:35,270 --> 00:02:36,630 David go with that one. 32 00:02:36,890 --> 00:02:38,450 Now if you view this thing 33 00:02:41,300 --> 00:02:47,990 just view this so delete and run it again here. 34 00:02:48,240 --> 00:02:54,170 We got three and four now five is deleted from this one and all the items are also deleted from here 35 00:02:55,260 --> 00:02:57,710 no same with this one here. 36 00:02:57,940 --> 00:03:00,610 If I just go feed this whole. 37 00:03:00,610 --> 00:03:14,020 Come on see and come on we change this one so copy that address change this one here one more princes 38 00:03:14,760 --> 00:03:22,640 and also replace this question mark with percentage is and now first at we view the items very well 39 00:03:22,640 --> 00:03:22,900 there. 40 00:03:23,870 --> 00:03:27,030 So David go with these three item. 41 00:03:27,440 --> 00:03:36,450 So we are going to delete this one so delete divisive we don't have anything there do that is all number 42 00:03:36,480 --> 00:03:48,360 to there save this one being done we get successful and now come on said save and run again we got only 43 00:03:48,360 --> 00:03:49,770 one note to do. 44 00:03:50,400 --> 00:03:54,330 So this is how you can delete the data from this database just this one. 45 00:03:55,010 --> 00:03:56,000 So thanks for watching. 46 00:03:56,000 --> 00:03:58,670 In the next video we learn that how we can update the data.