1 00:00:00,060 --> 00:00:07,360 Because in this, we will be seeing hope of them, our database, they send information. 2 00:00:07,650 --> 00:00:08,790 So let's get started. 3 00:00:09,030 --> 00:00:13,230 So here we can see there is a for information schemata tables. 4 00:00:19,370 --> 00:00:22,760 So let me get the information from the. 5 00:00:27,300 --> 00:00:34,410 So it released all the tables names, so you can see there is so much of information that's come up 6 00:00:34,620 --> 00:00:37,410 and see the scheme of this. 7 00:00:43,010 --> 00:00:50,300 So you can see they will catalog this one and it was Kimock, so Information's Kiwan, so which schema 8 00:00:51,230 --> 00:00:53,120 these papers belong to? 9 00:00:53,120 --> 00:00:53,720 And they were. 10 00:00:54,230 --> 00:00:56,990 So we have this committee will name Pavlovsky. 11 00:00:57,310 --> 00:01:06,650 OK, so what you can do is first you can find a number of tables and in those tables you need to retrieve 12 00:01:06,650 --> 00:01:07,700 the are the columns. 13 00:01:08,090 --> 00:01:12,410 You can see information schema dot columns where table names that they were. 14 00:01:13,580 --> 00:01:15,080 So let's go out and do that. 15 00:01:15,410 --> 00:01:19,980 Let's see how we can reach this one next to the. 16 00:01:43,360 --> 00:01:50,050 So Tricorn, guess we don't know that category promontories be prone to escorting them, so let's call 17 00:01:50,050 --> 00:01:55,510 police and let's go to this one, Firefox's 2.0 you already quote. 18 00:01:56,620 --> 00:02:03,000 So let me find a number of columns in those categories. 19 00:02:03,610 --> 00:02:05,710 So, of course, there are two columns. 20 00:02:06,220 --> 00:02:07,810 It will try for three columns. 21 00:02:07,960 --> 00:02:10,330 So there are only two columns. 22 00:02:11,830 --> 00:02:14,110 OK, since we know there are two columns. 23 00:02:15,070 --> 00:02:15,970 Union Serag. 24 00:02:22,800 --> 00:02:27,270 So there is urgency for Mr. is springtime. 25 00:02:30,960 --> 00:02:31,410 No. 26 00:02:34,170 --> 00:02:34,950 And. 27 00:02:44,550 --> 00:02:52,990 You can also put the here and you should see the B here, so that means two columns springtime. 28 00:02:53,100 --> 00:02:54,810 So that's more than enough. 29 00:02:57,190 --> 00:03:05,460 I know we need to select table name, right, because we know that in that schema, we have this table 30 00:03:05,460 --> 00:03:13,600 on the table name, come on, all from information as that tables. 31 00:03:15,620 --> 00:03:21,730 And he didn't know you can see these are the tables, so you can dump using the for loop in Python, 32 00:03:22,130 --> 00:03:24,670 so it's we'll see about Python later. 33 00:03:25,790 --> 00:03:28,810 So these are the are the tables in the database. 34 00:03:34,150 --> 00:03:42,230 So what they're asking is that easy users and so this is the database that shows the credentials. 35 00:03:42,520 --> 00:03:43,630 So let's copy this. 36 00:03:50,400 --> 00:04:06,240 So that column not name commander from infa mission schema, not columns where they will name you this 37 00:04:06,240 --> 00:04:06,510 one. 38 00:04:10,540 --> 00:04:18,340 And I don't know, you can see all the columns, username this one and the password, so these two are 39 00:04:18,340 --> 00:04:18,970 good columns. 40 00:04:28,590 --> 00:04:29,940 Sort of Mr here. 41 00:04:36,840 --> 00:04:39,000 So we need to get this from this. 42 00:04:44,880 --> 00:04:45,510 From. 43 00:04:48,750 --> 00:04:49,980 So what is the username? 44 00:04:53,580 --> 00:04:54,990 So what is the table now? 45 00:04:55,560 --> 00:04:56,040 This one? 46 00:05:09,320 --> 00:05:09,770 From. 47 00:05:11,310 --> 00:05:20,820 This Dobrynin copy here, this so you can see we got the credentials Viña administrator, so you can 48 00:05:20,820 --> 00:05:26,820 copy this one and go to my account login with that mashaba credentials. 49 00:05:31,630 --> 00:05:39,680 So it sounds like in some cases you need to set up the scheme or that they were there. 50 00:05:39,790 --> 00:05:41,740 So how you would do this is. 51 00:05:48,150 --> 00:05:48,530 So. 52 00:05:51,350 --> 00:05:57,530 So there was Quima, so this will be a rare case where you need to Kemar. 53 00:06:00,820 --> 00:06:01,630 Whatever name. 54 00:06:03,760 --> 00:06:10,380 From information schema that not was. 55 00:06:14,010 --> 00:06:19,760 So the first one is the ski, one second one is the table now search for you on the school. 56 00:06:20,040 --> 00:06:24,850 So public is the ski mask and this one is the table. 57 00:06:28,590 --> 00:06:35,430 OK, so from inside of users, so you can say, I probably could. 58 00:06:37,010 --> 00:06:39,870 Not this table, so we get the same result. 59 00:06:40,100 --> 00:06:48,160 So I guess if a normal deboning fails, you can try the schemata to win it. 60 00:06:48,350 --> 00:06:49,900 So it will be very easy one. 61 00:06:53,220 --> 00:06:56,140 So let's go over and see for the record. 62 00:06:56,370 --> 00:07:01,200 So this will be more similar, except only this infection's pool. 63 00:07:01,270 --> 00:07:08,450 So Pashtunistan, the tables are on the roofs and in the stables, you will contain some information. 64 00:07:08,670 --> 00:07:15,630 And in that we send our columns, our columns with the table is goes to our dessert table. 65 00:07:16,020 --> 00:07:22,680 OK, so we show you how to find the juicy information from those tables. 66 00:07:48,730 --> 00:07:49,020 Well. 67 00:08:18,920 --> 00:08:24,860 So let's click on anything that's copy and go to this one, Firefox. 68 00:08:26,690 --> 00:08:34,850 So, as usual, let's find the columns starting with the second column, so we have this order, so 69 00:08:34,850 --> 00:08:38,330 that means there are two columns with sort of three. 70 00:08:39,440 --> 00:08:41,420 So there are only two columns. 71 00:08:41,900 --> 00:08:47,250 So in those terms, we need to specify which one retains those type. 72 00:08:50,280 --> 00:08:58,070 So remember, this is the Oracle database, right, not from the original associated with our version, 73 00:08:58,800 --> 00:09:00,400 so the first one is string. 74 00:09:07,440 --> 00:09:09,320 So the second one is also sitting down. 75 00:09:09,410 --> 00:09:10,880 So it's. 76 00:09:17,320 --> 00:09:29,480 So what we have is there is result was already our articles go to this hope center. 77 00:09:38,470 --> 00:09:45,270 So you can see this is the cognizable Karamzin, Mr Debnam crushed on empty business. 78 00:09:46,750 --> 00:09:49,090 So now we can use the table. 79 00:09:49,900 --> 00:09:55,450 So let's go and see table nul from. 80 00:09:55,870 --> 00:10:00,720 So which one are tables, right. 81 00:10:02,610 --> 00:10:05,540 So you can see we got the ah, the was. 82 00:10:07,190 --> 00:10:15,950 Now, the search for you this underscore, so this is the day where we have the credentials. 83 00:10:30,030 --> 00:10:36,530 So what they're telling us to find the quorums using these are condoms, right? 84 00:10:36,570 --> 00:10:39,450 There are seven condoms. 85 00:10:40,570 --> 00:10:48,280 So in order to build this connection properly and need where you need to know what the are the default 86 00:10:48,790 --> 00:10:53,880 like these databases and there was so here we have the table and the column. 87 00:10:54,310 --> 00:11:04,480 So there will be more than enough third column on the school name, not from our two columns. 88 00:11:06,340 --> 00:11:06,910 And then. 89 00:11:10,130 --> 00:11:15,700 OK, sorry, we need to specify where terrible name Zegas to. 90 00:11:19,130 --> 00:11:22,200 This one uses front and center. 91 00:11:23,630 --> 00:11:29,120 Now we got the two columns, password one and the username one. 92 00:11:36,810 --> 00:11:42,560 So copy this so you can also put the user name first on the source. 93 00:11:42,960 --> 00:11:52,380 So the order does not matter in this case, it's password and username from which they will this users 94 00:11:52,380 --> 00:11:52,740 from. 95 00:11:55,820 --> 00:12:01,670 And no, he didn't know you got the credentials, admission of this so-called. 96 00:12:10,030 --> 00:12:16,950 So these are the successful credentials, so you can see this is very simple to operate using a patent. 97 00:12:17,260 --> 00:12:23,290 So I'm not going to explain the code now because it took me nearly two days to write this. 98 00:12:24,610 --> 00:12:26,150 So I will just explain the code. 99 00:12:27,610 --> 00:12:29,360 So this format is good. 100 00:12:30,520 --> 00:12:34,840 So this function normally is it takes the user and number of forums. 101 00:12:35,050 --> 00:12:41,310 And in those columns I have already defined the command using the previous functions, using the columns. 102 00:12:41,950 --> 00:12:47,760 So here I am passing the first information. 103 00:12:47,830 --> 00:12:50,230 So whenever you type normally gives. 104 00:12:50,680 --> 00:12:53,080 So this will be the our best page. 105 00:12:53,380 --> 00:12:58,360 So whatever we are selecting the information that will be added to this particular page. 106 00:12:58,630 --> 00:13:05,350 So what I can do is I can take the space page and I can take the result page. 107 00:13:05,350 --> 00:13:08,120 After this connection, I can make the discussion. 108 00:13:08,380 --> 00:13:11,530 So we give those which are unique, each of the different ones. 109 00:13:12,100 --> 00:13:15,940 So that's how you each have information, additional information from this page. 110 00:13:16,990 --> 00:13:22,840 So I'm using this one and then I'm constructing the query. 111 00:13:22,840 --> 00:13:26,480 Select which side of the table. 112 00:13:26,500 --> 00:13:33,970 Now, from this information schema tables and then I'm opening it to the tables column tables. 113 00:13:35,380 --> 00:13:38,160 So here I am opening the tables. 114 00:13:38,530 --> 00:13:46,110 And if the table I'm there will be, uh, this, uh, table headers. 115 00:13:46,570 --> 00:13:49,690 So this may be able to do in both of these. 116 00:13:50,740 --> 00:13:51,570 You can see here. 117 00:13:52,960 --> 00:13:57,010 And if you go back here, you can see I can give this to happen. 118 00:13:57,220 --> 00:14:03,610 So whenever you extend this using the beautiful soup, you will get some few of these in the same page. 119 00:14:03,640 --> 00:14:05,590 So that's where I'm going to clear them. 120 00:14:05,920 --> 00:14:11,390 So finally, I get the tables are the tables negativeness, so in the tables. 121 00:14:11,440 --> 00:14:16,450 So for each table I'm going to draw from this and coding for this. 122 00:14:16,490 --> 00:14:20,190 Uh, you are so union select from the following schema. 123 00:14:20,290 --> 00:14:24,130 The columns we're telling them is close to the looping of the. 124 00:14:26,860 --> 00:14:33,760 And then I am putting in the desert intertemporal and using the discover of the desert, so in the desert 125 00:14:33,760 --> 00:14:35,520 I'm expecting these columns. 126 00:14:36,610 --> 00:14:41,300 So so these columns are the dictionary. 127 00:14:41,350 --> 00:14:47,070 So the key contains the table name and the value contents that are the columns, you know. 128 00:14:48,940 --> 00:14:54,670 So in those columns, I'm retreating or the keys, that means that they were names and I'm extracting 129 00:14:54,670 --> 00:14:56,310 the data. 130 00:14:56,590 --> 00:15:00,940 So from that, I mean, the keys, that means every key every day. 131 00:15:01,630 --> 00:15:09,820 So I'm getting it and I have to bring it to the normal fire. 132 00:15:10,030 --> 00:15:14,990 Then I also asked the help from this car to visualize these tables. 133 00:15:15,430 --> 00:15:19,760 Then one of the friends said that this rich model. 134 00:15:19,780 --> 00:15:21,200 So here we have the table. 135 00:15:21,400 --> 00:15:26,890 So you need to construct any so you can just add the Rosengard secret under the table format. 136 00:15:27,820 --> 00:15:31,030 So to test this, let's go and copy the order. 137 00:15:40,280 --> 00:15:41,580 So let's go with this one. 138 00:15:43,220 --> 00:15:46,670 So here you need to push this you are. 139 00:15:49,020 --> 00:15:54,840 So first, we're using our nation function to determine number of columns, and in those columns, you 140 00:15:54,840 --> 00:15:56,870 are determining which column, certain columns. 141 00:15:57,480 --> 00:16:00,890 So and then I'm going to dump that right there. 142 00:16:02,130 --> 00:16:07,740 So let's, uh, I'm modifying this a little bit to the six tables. 143 00:16:08,130 --> 00:16:10,660 The first six tables will get the information. 144 00:16:11,010 --> 00:16:16,980 So if I want to show you the hard information, it will take so much of, uh, time to run this model. 145 00:16:17,280 --> 00:16:18,120 So run this. 146 00:16:31,950 --> 00:16:36,120 So this is a query we are sending and we are getting this response. 147 00:16:37,850 --> 00:16:40,200 So are these people starting to. 148 00:16:40,310 --> 00:16:45,420 So let's increase the number to 62 or a certain. 149 00:16:45,620 --> 00:16:48,230 So instead of this pen, you can sell them to afterwards. 150 00:17:10,540 --> 00:17:17,530 So you can see this dictionary is the six tables with the columns. 151 00:17:20,170 --> 00:17:22,480 So these do not have any information. 152 00:17:23,260 --> 00:17:24,720 OK, let's go and see. 153 00:17:36,670 --> 00:17:38,680 Well, let's try to then pardon for Mr.. 154 00:18:15,320 --> 00:18:23,090 OK, yes, I am stopping here, it is taking so much time, so I will show you the recent dump, so 155 00:18:23,090 --> 00:18:24,070 I have it on that comment. 156 00:18:24,080 --> 00:18:25,690 I, however, need to fight it now. 157 00:18:26,180 --> 00:18:30,110 So this is what it looked like after the current executes. 158 00:18:30,920 --> 00:18:32,630 So you get the art in there. 159 00:18:32,900 --> 00:18:34,970 Nice table format.