WEBVTT 00:00.420 --> 00:00.960 Welcome back. 00:00.960 --> 00:07.970 Now let us quickly jump fan our update and delete functionality so Bitcoin will require full fields 00:07.980 --> 00:15.850 actually it would require a portfolio already as well as quite a name price and coin on the portfolio 00:15.850 --> 00:18.410 today would be for our condition. 00:18.640 --> 00:21.920 And then these three things if we want to update anything. 00:22.190 --> 00:23.220 So let me take them 00:26.330 --> 00:27.820 so let me copy this one. 00:27.860 --> 00:30.350 We need to edit everything carefully. 00:30.350 --> 00:33.740 The first thing we need to edit is I need to increase the rule number 00:36.990 --> 00:41.560 then this would be our portfolio idea and you need to use a unique name. 00:41.670 --> 00:46.020 I know I'm going to mess a lot with names but be careful with that. 00:46.050 --> 00:47.340 This would be our symbol. 00:47.340 --> 00:50.920 I just need to write it as a did. 00:51.020 --> 00:52.520 Also this phrase 00:58.050 --> 01:05.450 and then this will be done in the amount of bit once that is done. 01:05.520 --> 01:07.280 Also don't forget to change your text. 01:07.650 --> 01:09.240 And then you know the function 01:17.400 --> 01:20.500 and had I ever name it as a bitcoin. 01:20.700 --> 01:25.770 Once that is done let me jump back to my top and add a bitcoin function. 01:25.770 --> 01:31.500 So all I have to do is create a function of the coin then use my cursor again then execute method. 01:31.620 --> 01:36.860 And inside this I would be using a command called a dead coin then set. 01:37.110 --> 01:44.280 Then if I need to change anything like my symbol prize or among and then I need to pass my condition 01:44.310 --> 01:45.330 that is there. 01:45.630 --> 01:51.840 And the idea once that is done we need to pass the entities that is our four entities the first one 01:51.840 --> 01:53.000 would be our symbol. 01:53.000 --> 01:59.820 Prize amount and then our I.T. so all you have to do is pass it up and then you have to remember their 01:59.820 --> 02:00.180 names. 02:00.180 --> 02:03.420 So it would be a symbol of the prize a big amount of debt. 02:03.510 --> 02:04.910 And then the board idea of the 02:19.780 --> 02:22.670 once that is done don't forget to add your comment. 02:22.690 --> 02:23.710 This looks fine to me. 02:23.710 --> 02:27.120 Let me run this one and then we need to add they need functionality. 02:27.190 --> 02:28.270 We now have a B. 02:28.530 --> 02:36.920 So let me update r b and b c if I take five as my I.T. and then symbol as being B so we have bought 02:36.980 --> 02:43.660 B at 10 so instead of using 5 planes let me use it as three coin and a B. 02:44.020 --> 02:46.270 Now I need to refresh this one. 02:46.550 --> 02:52.310 So it's now three coin and we have fixed this one and I just am back to my database here. 02:52.540 --> 02:55.960 We have five refresh this one it's three. 02:55.960 --> 02:58.050 So that's all we can do a bit. 02:58.090 --> 03:03.930 Let me also I believe functionality but remember for delete We just need the I.T.. 03:03.950 --> 03:12.820 So that would be our poor data. 03:13.370 --> 03:20.490 Just make a dash plus three and also change column to zero and that would be forward 03:31.060 --> 03:34.830 to basically it involves lot of manual editing at this point of time. 03:34.870 --> 03:37.170 There are two answers that you might get bored. 03:37.270 --> 03:41.650 I would recommend you to just follow along with this because this is manual task. 03:41.800 --> 03:47.050 The next thing is I have added this to the functionality so I just need to add or delete function 03:53.330 --> 03:58.970 and head insert of that if you need to delete something you just need to use a query called delete from 03:58.970 --> 04:01.610 coin that has our table name there. 04:01.790 --> 04:10.990 I just need to maintain my I.D. so it would be all data delete and and don't forget to add a comma. 04:11.000 --> 04:18.120 Then because this is a couple and if you are not going to add a comma one element would not be to stop. 04:18.190 --> 04:20.100 It would be just inside that bracket. 04:20.230 --> 04:26.770 So don't forget to add a comma at the end of our first item on this one again. 04:26.770 --> 04:33.150 And suppose I need to delete that coin maybe BNP and delete this one. 04:33.330 --> 04:36.140 He faced this again. 04:36.410 --> 04:37.750 Don't forget this mess. 04:37.760 --> 04:39.960 We'll be clearing that but not currently. 04:40.110 --> 04:41.900 Yeah I have deleted that. 04:42.050 --> 04:45.540 You can hide this now because this one is from our previous leader. 04:45.590 --> 04:49.710 That is our previous reserved and these forward our updated results. 04:49.700 --> 04:57.140 If I go to my database refresh this one we not only have full that's fine and in the next lecture let 04:57.140 --> 05:01.060 us solve this mess because this one is currently creating a mess. 05:01.130 --> 05:07.760 It is all writing out previously and so what we need to do is we need to use some functionality before 05:07.760 --> 05:09.710 refreshing before updating. 05:09.710 --> 05:15.430 We need to clear a window and then or what I asked so that would be empty window. 05:15.470 --> 05:22.060 I hope you understand the functionality of insert coin a bit coin and delete coin in the next lecture 05:22.070 --> 05:26.500 let us focus on clearing our screen and then refreshing it. 05:26.680 --> 05:29.750 So that would be our simple task to create a new function. 05:29.930 --> 05:30.980 So see you in the next one. 05:30.990 --> 05:35.120 And good to see that you are falling the cities to create yolk in that application.