1 00:00:01,290 --> 00:00:08,700 So now we are going to learn some obscure Connery's other comments in this video and as you can see, 2 00:00:08,820 --> 00:00:17,280 how connected to my local MySQL server and I would explain the interface over here to get a much better 3 00:00:17,280 --> 00:00:18,720 feeling of undiscerning. 4 00:00:19,110 --> 00:00:20,310 And you can click on this file. 5 00:00:20,310 --> 00:00:27,240 You can create a new model or you can define your own database and a set of rules and you can open a 6 00:00:27,240 --> 00:00:28,150 new query type. 7 00:00:28,230 --> 00:00:29,610 It's the same like this. 8 00:00:32,190 --> 00:00:38,680 And you can also open this up, open a square script, if you will have any comments written in a script. 9 00:00:38,680 --> 00:00:46,200 And you can open that in the using this organized group and you can also open and you can also run a 10 00:00:46,440 --> 00:00:49,390 script and you can also call the tabs and scripts. 11 00:00:49,950 --> 00:00:55,980 So these are used for this opening and closing the scripts and you can choose the preferences if you 12 00:00:55,980 --> 00:01:03,960 want to and you can do the home banners and the next minute placement, etc. And in this quarter you 13 00:01:03,960 --> 00:01:10,830 can select the statements you want to execute either current statement or are the statements. 14 00:01:11,760 --> 00:01:19,440 So you can if you want to open another current to that, another database which is on another computer 15 00:01:19,440 --> 00:01:20,880 or any other part. 16 00:01:22,200 --> 00:01:28,830 So in this server, as you can see this one, you can click on this admission, the same settings you 17 00:01:29,100 --> 00:01:34,770 see under this server options and the tools you can configuration tools. 18 00:01:34,770 --> 00:01:37,530 You can back up the connections and restore those connections. 19 00:01:38,220 --> 00:01:40,610 So you can also use this scripting. 20 00:01:40,890 --> 00:01:43,650 You can execute the commands here. 21 00:01:44,280 --> 00:01:47,070 And we are not going to execute any scoops. 22 00:01:47,070 --> 00:01:48,060 No, no. 23 00:01:48,070 --> 00:01:49,410 What is click on this. 24 00:01:50,100 --> 00:01:54,180 So these key ones are like metadata for this database. 25 00:01:54,210 --> 00:01:59,730 It defines what columns are there, what tables are there and etc.. 26 00:02:00,090 --> 00:02:05,580 So these are the three databases that are provided in world with MySQL. 27 00:02:06,420 --> 00:02:13,350 I start to use the PowerPoint presentation to display my school of basics, but I thought it would take 28 00:02:13,350 --> 00:02:21,210 so much time because this my school is very long and also making PBT is I'm tired of this. 29 00:02:21,540 --> 00:02:26,640 But anyway, I will explain from basics this obscure statements. 30 00:02:27,720 --> 00:02:33,280 As you can see, there are two databases here, Sakinah and, uh, CIS and the works. 31 00:02:33,280 --> 00:02:35,750 This is the main database used by this school. 32 00:02:35,940 --> 00:02:39,700 And you can see these are these two are the sample data, which is a killer and the world. 33 00:02:39,930 --> 00:02:46,110 To click on this Aramaki, you can see this database has been expanded and this inWorld database, you 34 00:02:46,110 --> 00:02:49,140 have the tables, you score procedures and functions. 35 00:02:49,630 --> 00:02:54,000 So these functions are to automate this school statements. 36 00:02:54,000 --> 00:02:56,580 You can just call these functions and they will execute. 37 00:02:57,060 --> 00:02:59,430 And you can also click on these tables. 38 00:02:59,430 --> 00:03:04,170 And in these tables we will have the information in the rows and columns. 39 00:03:04,200 --> 00:03:07,770 These columns contains the actual data and the rows contains the values. 40 00:03:08,280 --> 00:03:12,620 And if you click on this city, you can see here the information it's telling you. 41 00:03:12,810 --> 00:03:18,020 So in this city table, I have the schema as no country, Kurdish population. 42 00:03:19,320 --> 00:03:27,330 So that means, uh, in this city I have some names contribute district and population to the same way 43 00:03:27,340 --> 00:03:28,530 if I could to this country. 44 00:03:28,530 --> 00:03:33,870 I have the name counterintelligence service area, and there is so much information about this. 45 00:03:34,290 --> 00:03:37,660 So I want to display this data. 46 00:03:37,770 --> 00:03:41,070 So how do you do this is first you need to use. 47 00:03:43,720 --> 00:03:56,380 Use a four letter word, so I'm this my high school education to that means capital use and smart use 48 00:03:56,380 --> 00:03:57,560 and capital is both awesome. 49 00:03:57,610 --> 00:03:59,320 You either one. 50 00:04:01,130 --> 00:04:09,540 But many developers use the capital letters for the school syntax comments like you select and so on. 51 00:04:10,400 --> 00:04:13,250 So first, we need to use this word for a run. 52 00:04:13,280 --> 00:04:17,570 This I need to click on this record to run this statement. 53 00:04:17,960 --> 00:04:19,980 And you can see here, this is the log. 54 00:04:20,000 --> 00:04:25,310 You can see the output we have that this useful. 55 00:04:25,580 --> 00:04:29,870 And you can if you go right over here, you can see this is the left banner. 56 00:04:30,170 --> 00:04:31,450 This is Breuker negating. 57 00:04:31,520 --> 00:04:32,870 Have to click on this. 58 00:04:33,170 --> 00:04:34,430 This will go off. 59 00:04:34,730 --> 00:04:41,120 And if you click on again, it will really just give us a update on this, though. 60 00:04:41,390 --> 00:04:44,750 Uh, you can see the click on this now. 61 00:04:44,750 --> 00:04:45,620 It will vanish. 62 00:04:46,100 --> 00:04:51,350 Now, if I click on this, it would reappear now in the same way, right there is the right window. 63 00:04:52,080 --> 00:04:55,160 Uh, you can add excursions. 64 00:04:56,250 --> 00:04:58,520 Uh, we don't want that for now. 65 00:04:58,520 --> 00:05:02,530 I am in this, uh, to disappear so fast. 66 00:05:02,690 --> 00:05:04,320 We have learned this useful. 67 00:05:04,340 --> 00:05:12,020 So this database will be use it as it may not like this obscure condenser pointer pointing to this or 68 00:05:12,170 --> 00:05:16,430 any operations we have will do will reflect in this database. 69 00:05:16,880 --> 00:05:20,000 So we are going to learn select committee. 70 00:05:20,090 --> 00:05:21,100 This is very important. 71 00:05:21,650 --> 00:05:29,090 And what we want to do, we want to start started in a sense, all the columns and we need to see from 72 00:05:30,620 --> 00:05:30,930 you on. 73 00:05:30,950 --> 00:05:33,850 These are the tables you want to display from, let's say, city. 74 00:05:34,940 --> 00:05:35,870 That's a city. 75 00:05:36,390 --> 00:05:44,720 And I can see this program is, uh, every line ends with semicolon in the same way as you can envision. 76 00:05:45,530 --> 00:05:53,710 Uh, but in the modern, uh, high school, uh, syntaxes, uh, even though if you do not put semicolon, 77 00:05:53,870 --> 00:06:01,280 uh, this is Kirkman's gets rejected, but it's best practice to know if I click on this icon. 78 00:06:03,310 --> 00:06:08,170 Uh, I can close this output using this, we don't want the output we want. 79 00:06:09,130 --> 00:06:10,120 We don't want drugs. 80 00:06:10,130 --> 00:06:13,840 We don't want only this output to expand this. 81 00:06:14,110 --> 00:06:19,370 You can see the whole information about this table in the city table. 82 00:06:19,510 --> 00:06:24,030 I have the illegal name column, country, district population. 83 00:06:24,280 --> 00:06:26,380 This top heading is called columns. 84 00:06:26,390 --> 00:06:29,800 You can see this is the column and this is this is this and this. 85 00:06:30,310 --> 00:06:37,420 And in the column I have the values one, two, three, four, etc. I have the values, Cowgill, Conder, 86 00:06:37,420 --> 00:06:39,970 etc. Connecticut district population as well. 87 00:06:40,150 --> 00:06:47,230 So this is called one drop and this is called the horizontal values are called rules and the vertical 88 00:06:47,650 --> 00:06:48,910 columns are columns. 89 00:06:49,600 --> 00:06:54,040 And I started started because I want to display all the columns. 90 00:06:54,280 --> 00:06:58,760 If I want to display only the column, I can say, uh. 91 00:07:00,940 --> 00:07:05,410 So if I click on this one, I can see there are only the ideas. 92 00:07:06,820 --> 00:07:14,130 So let me click on the star and click on this and I get the ah, the values. 93 00:07:14,380 --> 00:07:22,150 Now I can just particularly sort of two or three columns by supporting them with let's let them come 94 00:07:22,150 --> 00:07:24,850 up and just. 95 00:07:29,440 --> 00:07:33,130 So I think the syntax is correct. 96 00:07:33,610 --> 00:07:40,450 OK, now that's so if I run this, I will get only two columns verbatim. 97 00:07:40,450 --> 00:07:48,040 And so these are the basic derivations we have in my school. 98 00:07:48,880 --> 00:07:54,670 I can also say Sarac star from a country. 99 00:07:57,660 --> 00:08:00,760 Let me execute this, OK? 100 00:08:00,870 --> 00:08:03,220 There is a lot more information going on. 101 00:08:03,660 --> 00:08:11,880 You can see, though, this is a country called name continent region service area and their population, 102 00:08:11,880 --> 00:08:14,040 etc. As you can see, there is a value called. 103 00:08:14,640 --> 00:08:16,700 So no value represents nothing. 104 00:08:16,710 --> 00:08:24,060 It's just like placeholder to say that there is no information about this column and about this law. 105 00:08:24,260 --> 00:08:32,730 So suppose if you, uh, have some information but you don't know yet, but we want to find out in the 106 00:08:32,730 --> 00:08:33,030 future. 107 00:08:33,360 --> 00:08:38,970 So in that case, you can keep the value so that others can understand that the value is unavailable 108 00:08:38,970 --> 00:08:41,520 or it may be available in the future. 109 00:08:41,550 --> 00:08:45,770 So it's like a placeholder if you don't know the value you can put here. 110 00:08:46,440 --> 00:08:49,920 So these are the big databases available for them. 111 00:08:50,430 --> 00:08:52,840 But we do not want the database. 112 00:08:53,430 --> 00:08:56,340 We are going to create our own sample databases. 113 00:08:56,370 --> 00:09:02,160 Let me call this output to create a database we need to go create. 114 00:09:04,460 --> 00:09:05,900 Database and database, no. 115 00:09:08,750 --> 00:09:17,780 Let's say students, so we are going to clear the database kada students at Mexica this. 116 00:09:19,360 --> 00:09:24,310 And you can see there is no assurance that the best way to handle this, you want to click the button 117 00:09:24,550 --> 00:09:31,360 to see the changes and you can see there is the student database. 118 00:09:31,630 --> 00:09:39,250 So this is not highlighted, but, uh, the world has the ball ball because, uh, previous comments 119 00:09:39,250 --> 00:09:47,440 we have used that use all the, uh, Quarrie that swing this world is in the, uh, accoustic. 120 00:09:47,440 --> 00:09:53,680 So we need to get the students as an to we need to say we can do this great. 121 00:09:53,690 --> 00:09:55,930 That the students are in a school. 122 00:09:55,940 --> 00:09:59,150 You can put two hyphens and the space to create a comment. 123 00:09:59,170 --> 00:10:01,170 So this line will be ignored. 124 00:10:01,330 --> 00:10:05,110 And if you can this nothing will happen because this is a comment. 125 00:10:05,620 --> 00:10:10,650 And this comment is very important in a school inflection point of view. 126 00:10:12,040 --> 00:10:20,970 So I can say use students or I can just Double-Click on the students to make sure that this is actually 127 00:10:20,970 --> 00:10:21,370 the best. 128 00:10:21,700 --> 00:10:24,750 So I get on this one and shouldn't be going back again. 129 00:10:24,760 --> 00:10:28,490 I figured if I double click on this world, it will be Comsec to know. 130 00:10:28,690 --> 00:10:31,480 However, we will execute this, uh, statement. 131 00:10:31,480 --> 00:10:40,710 You students don't worry if I use the statements Kuwaiti's or any other, uh, uh, language. 132 00:10:40,870 --> 00:10:42,970 What are some recent statements are saying? 133 00:10:44,380 --> 00:10:48,770 OK, now my students database is inactive. 134 00:10:48,940 --> 00:10:56,560 It is always, uh, a good method to use the database you are, uh, performing. 135 00:10:57,160 --> 00:11:07,320 I mean, this that I database name, uh, in front of whatever before the any changes go into this by 136 00:11:07,330 --> 00:11:07,780 students. 137 00:11:08,320 --> 00:11:12,730 Uh, this make sure that we are actually performing the operations on the students database. 138 00:11:14,110 --> 00:11:16,440 So we do not have any tables. 139 00:11:16,450 --> 00:11:20,520 Not this is empty tables, empty database. 140 00:11:20,560 --> 00:11:21,750 We need to create the table. 141 00:11:21,750 --> 00:11:28,000 Lets to do that the secret uh table. 142 00:11:28,660 --> 00:11:32,860 We ritzier our table. 143 00:11:33,370 --> 00:11:38,560 We need to put the table name that's uh in for. 144 00:11:40,600 --> 00:11:47,900 And we need to select the types of columns we need to add into this info table. 145 00:11:48,700 --> 00:11:55,780 So let me say open bracket and in this open bracket, we need to define the column values column. 146 00:11:56,280 --> 00:11:59,170 Uh, better let's it. 147 00:11:59,890 --> 00:12:03,990 So every student have the idea and the data for this idea is integer. 148 00:12:05,740 --> 00:12:09,840 So I want to serve first the underscore name. 149 00:12:10,180 --> 00:12:11,740 So we shouldn't have the first name. 150 00:12:11,740 --> 00:12:15,700 And I can say where worker of 250. 151 00:12:16,090 --> 00:12:25,480 This is like ASCII, sorry, NC you can see 256, uh ASCII plus extended ASCII values can put this as 152 00:12:25,480 --> 00:12:25,960 it first. 153 00:12:27,190 --> 00:12:27,480 Right. 154 00:12:27,500 --> 00:12:29,800 This is the basic syntax of DIWAKAR. 155 00:12:29,800 --> 00:12:32,340 I don't want to go in depth into these variables. 156 00:12:32,350 --> 00:12:36,550 I just explain the basic values that are integers and workers. 157 00:12:36,550 --> 00:12:43,310 And there are actually in the sense a lot of uh, uh, LNT characters. 158 00:12:43,330 --> 00:12:48,090 OK, a student can have a last last name. 159 00:12:49,630 --> 00:12:58,300 Last name is also where care workers sense verbal character and she can say open brackets. 160 00:12:58,310 --> 00:13:04,250 You can see where various options were to differ. 161 00:13:04,510 --> 00:13:13,150 And we have the first name, last name until the last three four underscore number. 162 00:13:15,090 --> 00:13:23,280 For no reason right now, I can successfully cross this, uh, braggarts and put the semi current let 163 00:13:23,280 --> 00:13:27,810 me execute this query for a fresh this. 164 00:13:27,810 --> 00:13:29,610 You can see there is a table created in. 165 00:13:31,820 --> 00:13:36,220 So we do not want this because I want I want I'm going to do this. 166 00:13:37,250 --> 00:13:41,240 Now, let's start from, uh, Disinfo. 167 00:13:43,430 --> 00:13:48,310 To see what other values are there in the info table. 168 00:13:50,800 --> 00:13:57,820 Let me run this query can see there is there is no let up because we just created this table. 169 00:13:57,820 --> 00:14:00,220 And what this is, this is called schema. 170 00:14:00,370 --> 00:14:06,480 And also there are other countries and the concept Koliada diagrams that is into the relationship diagrams. 171 00:14:07,090 --> 00:14:14,170 You can just map these translations using this relationship diagrams in a diagrammatically. 172 00:14:14,410 --> 00:14:22,780 That's why this is this database, as is called Relational Database Management System RDBMS, because 173 00:14:22,780 --> 00:14:29,200 we can, uh, connect these databases tables using these, uh, relationships. 174 00:14:29,350 --> 00:14:36,970 So we will see how we can connect using the joints, uh, in the end of this area are within a few moments. 175 00:14:37,360 --> 00:14:43,210 So now if I start this structure from info, I have got no data because we just created the table and 176 00:14:43,210 --> 00:14:48,220 we have no data is you can see there is a different name and phone number. 177 00:14:48,220 --> 00:14:48,500 Right. 178 00:14:49,810 --> 00:14:55,620 So we are going to insert some values into this crew that I want to insert into. 179 00:14:56,440 --> 00:14:58,060 I want to specify the table. 180 00:14:58,060 --> 00:15:05,020 I want to insert I want to insert into enforceable and enforceable and I consider brackets. 181 00:15:05,230 --> 00:15:11,050 And under what columns I need to insert, I want to insert our first name or phone number. 182 00:15:11,380 --> 00:15:22,240 If I want to insert into all these columns, I can just simply say, well, well, you s and I should 183 00:15:22,240 --> 00:15:25,200 do in order the values of the first row. 184 00:15:26,500 --> 00:15:32,710 So I, I'm, I'm going to enter the first row that is ID number, let's say one comma and first term 185 00:15:32,880 --> 00:15:37,150 to Nagasaki, which is my name. 186 00:15:37,570 --> 00:15:45,550 And let's, let's say last night musicological nickel and then let's say for number one, two, three, 187 00:15:45,550 --> 00:15:48,540 four, five and put the same in Canada. 188 00:15:48,730 --> 00:15:56,200 So what this means is we are inserting into this in four tables and the values are one. 189 00:15:56,200 --> 00:16:02,560 This goes into the idea and this now goes into this name and this nickel goes into the last name and 190 00:16:02,560 --> 00:16:04,360 one to if it goes to the phone number. 191 00:16:06,240 --> 00:16:11,040 So if you want to insert into only first name and the last name, you need to say. 192 00:16:12,300 --> 00:16:13,350 Info off. 193 00:16:16,830 --> 00:16:18,720 For first name and the last name. 194 00:16:28,640 --> 00:16:30,570 Fashion for them. 195 00:16:30,670 --> 00:16:38,500 I need to switch to only two values and the two are going to go into these two respective columns first 196 00:16:38,680 --> 00:16:39,410 and last name. 197 00:16:39,430 --> 00:16:40,660 So I don't want to do that. 198 00:16:40,660 --> 00:16:48,850 I want to put in these exact values into this exact columns because there are four columns and the four 199 00:16:48,880 --> 00:16:52,930 values of the first, and that if you exclude this. 200 00:16:54,870 --> 00:16:55,630 OK. 201 00:16:55,860 --> 00:17:02,060 I did not use the static statement to refer to the data structure from. 202 00:17:03,440 --> 00:17:15,260 In four, so if I run this query, as you can see, these come this insert is has been neglected and 203 00:17:15,260 --> 00:17:17,010 we got the first one. 204 00:17:17,030 --> 00:17:18,640 Now, one, two, three, four, five. 205 00:17:19,250 --> 00:17:25,330 So let's try to insert some more values, some morals. 206 00:17:25,340 --> 00:17:27,260 I mean, let me copy this. 207 00:17:31,950 --> 00:17:36,600 So let me try to insert the first two three. 208 00:17:38,010 --> 00:17:45,210 For so let me add some of the students so I don't have any friends that say Acer is a laptop. 209 00:17:46,630 --> 00:17:48,370 A sort of Strix. 210 00:17:50,230 --> 00:17:52,150 And let's say 100. 211 00:17:54,470 --> 00:17:59,150 And let's talk to the Navy's Lenovo. 212 00:18:01,370 --> 00:18:04,480 It's a last name for this Runaway's Legian. 213 00:18:06,180 --> 00:18:10,550 And let's you know, the phone number of this region is 500. 214 00:18:11,190 --> 00:18:16,800 I'm just putting for one purpose and let's say Iesus. 215 00:18:18,070 --> 00:18:21,000 And rashness, let's roll. 216 00:18:23,470 --> 00:18:29,230 Let's say the very one, two, three, one, two, three, four ruffian's, so we are going to insert 217 00:18:29,440 --> 00:18:32,050 three more rules and let's see. 218 00:18:34,800 --> 00:18:39,500 And there you can go, there you can see the four walls have been inserted, first name, last name 219 00:18:39,540 --> 00:18:40,650 and the phone numbers. 220 00:18:46,510 --> 00:18:56,110 So this is the, um, basic the my escort clients are let us see some more. 221 00:19:00,840 --> 00:19:10,770 So I have a comment on these comments now, we need to see some of these filter options from the statement, 222 00:19:11,310 --> 00:19:13,260 there is a condition called bear. 223 00:19:14,840 --> 00:19:23,260 And this word can be used to filter the options, uh, certain with this select statement I can see 224 00:19:23,870 --> 00:19:30,280 are the results are the columns from the info where I can say it is greater than two. 225 00:19:31,490 --> 00:19:33,440 So I can say it is greater than two. 226 00:19:33,860 --> 00:19:42,860 If I select this for execute this now, I will see the output only with the rules that are greater than 227 00:19:42,860 --> 00:19:43,100 two. 228 00:19:43,250 --> 00:19:45,460 So we got the three fatalities. 229 00:19:45,830 --> 00:19:50,390 So that's how you use the word to filter these ideas. 230 00:19:51,530 --> 00:19:58,880 So you can also put the greater than as equals two to get two, three, four rows and you can put the 231 00:19:58,880 --> 00:20:01,700 rest on articles two together, one, two rows. 232 00:20:02,090 --> 00:20:05,810 And you can also, uh, put the rest then. 233 00:20:08,270 --> 00:20:10,340 Less than two to get the first true. 234 00:20:11,990 --> 00:20:18,060 And you can also put this greater than or greater than a than rather than three. 235 00:20:19,400 --> 00:20:20,870 This is not as equals. 236 00:20:21,040 --> 00:20:27,220 You can put, uh, exclamation as equals to to get decided not as close to three. 237 00:20:27,530 --> 00:20:32,090 So I get the rules with the I.D. one, two, four and not three. 238 00:20:33,590 --> 00:20:41,210 As you can see, one, two, four, and not so this is another form for the not equal to some of these 239 00:20:41,210 --> 00:20:49,050 databases of Resident Getdown and some of these databases support databases like the obscure maybe actually 240 00:20:49,110 --> 00:20:51,920 suppose less Democratic than audemars because of all this. 241 00:20:52,830 --> 00:20:56,700 It's good practice to know these alternatives. 242 00:20:57,230 --> 00:20:58,460 So let me show ID. 243 00:21:01,470 --> 00:21:10,260 So I got this one botrytis, so this is how you can use the word and you can also filter with the ah 244 00:21:10,260 --> 00:21:17,100 and the, uh, statement you can see and, uh, let's see. 245 00:21:21,370 --> 00:21:24,430 The for no less than a dozen. 246 00:21:26,690 --> 00:21:33,440 So what this means is we are starting all the columns from the info table where it should be less than 247 00:21:33,440 --> 00:21:36,770 three and also for no less than a thousand. 248 00:21:37,280 --> 00:21:49,510 So if I execute this, I get the second and third this and can be used to a union, these conditions. 249 00:21:49,520 --> 00:21:52,330 So this is one condition and this is the second condition. 250 00:21:52,340 --> 00:21:57,470 If only both conditions are true, then only this output will be displayed. 251 00:21:57,590 --> 00:22:03,080 Otherwise it will get a blank output based on these statements we have given, based on the conditions 252 00:22:03,080 --> 00:22:03,530 we are given. 253 00:22:03,560 --> 00:22:04,760 Let me ask you this. 254 00:22:05,460 --> 00:22:11,500 As you can see, two and three words, because less than not equal to three and also for no less than 255 00:22:11,510 --> 00:22:11,630 two. 256 00:22:11,870 --> 00:22:15,320 We got these two and you can also put the other. 257 00:22:18,930 --> 00:22:26,670 And so, as you can see, it is less than or equal to three or four, no less than dozen. 258 00:22:27,360 --> 00:22:32,710 So since this I.D. culture is done, this photo has been filled. 259 00:22:33,000 --> 00:22:39,270 But why this has been displayed because the phone number of this group has been one to three and it's 260 00:22:39,270 --> 00:22:40,100 less than today. 261 00:22:40,110 --> 00:22:43,150 So that's why we can we got this photo also. 262 00:22:44,670 --> 00:22:47,960 So that is how you use the R and the end. 263 00:22:51,930 --> 00:22:52,740 And. 264 00:22:55,090 --> 00:22:59,050 You can use the color distinct. 265 00:23:06,950 --> 00:23:08,870 So is that a distinct. 266 00:23:10,980 --> 00:23:17,880 So there are no any repeater values of this, so just you can also say they are using their distinct 267 00:23:19,410 --> 00:23:25,760 and OK, I have made the mistake a gaming laptops name is Predator. 268 00:23:25,770 --> 00:23:30,750 If I want to make a bet this value, I can say. 269 00:23:32,270 --> 00:23:33,110 I bet. 270 00:23:35,370 --> 00:23:46,470 A bird in for updating for the world said the last name is equal to where they want to, I want to see 271 00:23:47,130 --> 00:23:52,830 change that strikes into the Predator because there is a gaming laptops name is Predator, and I want 272 00:23:52,830 --> 00:23:54,990 to change the last name. 273 00:23:56,020 --> 00:24:04,900 The calls to prayer there are so far this comment, this is a very dangerous comment because if we do 274 00:24:04,900 --> 00:24:09,390 not give the condition, it will apply to all the rules. 275 00:24:09,520 --> 00:24:16,270 Face this attitude, this one, this predator will be placed under this strict region and rule out this 276 00:24:16,270 --> 00:24:16,720 radical. 277 00:24:17,920 --> 00:24:19,740 That's why this is very dangerous comment. 278 00:24:19,780 --> 00:24:22,000 And you only update this. 279 00:24:24,480 --> 00:24:33,500 Use these statements very carefully and also put where and I want to share ideas close to two of every 280 00:24:33,540 --> 00:24:36,170 single is that you can choose whatever you want. 281 00:24:36,510 --> 00:24:40,700 I want to choose the idea for run this. 282 00:24:43,290 --> 00:24:49,530 So it says that record you are using, save a bit more and try to build a world without work. 283 00:24:49,950 --> 00:24:55,050 So this is like my school, save more for our patients. 284 00:24:55,230 --> 00:24:56,850 So patients, you need to. 285 00:24:57,160 --> 00:24:59,590 What we want to see is you need to say. 286 00:25:03,180 --> 00:25:05,580 Said, Yes, Kule. 287 00:25:08,550 --> 00:25:09,350 Save. 288 00:25:10,570 --> 00:25:13,210 A bit is equal to zero. 289 00:25:15,520 --> 00:25:16,750 So you run this. 290 00:25:18,740 --> 00:25:24,570 And now you can see so after setting this up, there was as good as Alphabet's physiological. 291 00:25:24,860 --> 00:25:28,310 I actually ran this set up as you wish. 292 00:25:28,880 --> 00:25:33,160 So my are Strix has been replaced by rewriter. 293 00:25:33,410 --> 00:25:40,690 So that's why you can see this is very important to keep out of their condition. 294 00:25:41,780 --> 00:25:48,200 And if you do not put that, are the will be the replaceable predator sort of Miklós this. 295 00:25:53,370 --> 00:25:56,970 All right, I think I said are the basics. 296 00:25:57,160 --> 00:26:05,160 Now let's move on to the joints so I have a few more set theory in mathematics, like, yeah, union 297 00:26:05,160 --> 00:26:09,140 B, Section B and disjointing very, very easy. 298 00:26:09,480 --> 00:26:11,320 So don't get confused. 299 00:26:11,340 --> 00:26:16,290 I will explain in a very clear manner that first let me 300 00:26:18,900 --> 00:26:22,290 display the results of the info table. 301 00:26:22,320 --> 00:26:24,960 We have the I.D. of these students. 302 00:26:25,620 --> 00:26:27,870 Let me create a new database. 303 00:26:30,070 --> 00:26:31,090 So. 304 00:26:37,470 --> 00:26:47,970 OK, let me create a new database to create the tubists. 305 00:26:51,960 --> 00:26:53,170 Richard Marks. 306 00:26:53,310 --> 00:26:58,110 So why do not clear that up as we can simply create another table, right? 307 00:27:01,670 --> 00:27:03,380 Ritsa, Gruyère. 308 00:27:07,710 --> 00:27:08,190 Creer. 309 00:27:12,170 --> 00:27:22,630 Bill Marks, so what we're going to do is we should have this one column, uh, like equal in two or 310 00:27:22,630 --> 00:27:26,380 three tables, then we can join those two there was using the same column. 311 00:27:26,560 --> 00:27:27,790 So let me explain this. 312 00:27:29,620 --> 00:27:31,860 So create table marks. 313 00:27:31,870 --> 00:27:40,210 And I want to say it by putting the point and I want to say, uh, Marks. 314 00:27:44,660 --> 00:27:48,950 And the are also integer, so me correct this. 315 00:27:51,040 --> 00:27:56,500 You can see so there are two levels, let me go and insert somewhere else into this. 316 00:28:01,640 --> 00:28:07,460 Inserting tool marks that values. 317 00:28:10,150 --> 00:28:22,560 Well, you s let me go and insert 81, that cigar that marks 100 marks, so let me copy this in such 318 00:28:22,570 --> 00:28:26,470 statement and post multiple times. 319 00:28:29,210 --> 00:28:39,580 So I want to create the second lady and so Marks is to three hundred thirty marks is equal to two 200 320 00:28:40,130 --> 00:28:41,820 and now I'm going to put the idea. 321 00:28:41,840 --> 00:28:53,350 It is not enough in for, let's say, eight to eighty, eighty, eighty and how the monks 900. 322 00:28:53,850 --> 00:28:55,670 So let me go and execute this. 323 00:28:56,900 --> 00:28:59,590 She can see are the statements have been executed. 324 00:28:59,600 --> 00:29:03,320 And let me start from. 325 00:29:05,170 --> 00:29:05,980 Marks. 326 00:29:11,680 --> 00:29:18,020 As you can see, there is I.D. one, it is one, two, three, and the marks, 100, 200, 200, 900. 327 00:29:18,460 --> 00:29:20,710 Let me also display the info. 328 00:29:24,290 --> 00:29:33,860 So these are the student names as these are the students, one, two, three, four, and previously 329 00:29:34,490 --> 00:29:38,670 we have the marks and observe only the authorities. 330 00:29:38,690 --> 00:29:43,640 We have one, two, three, four, and the details of the students if you exclude the marks. 331 00:29:44,240 --> 00:29:47,950 So we have the I.D. one, two, 380 and the marks. 332 00:29:48,120 --> 00:29:52,670 So what we can join these two was using these marks. 333 00:29:53,600 --> 00:29:56,520 So I will show you how to do the joint. 334 00:29:56,720 --> 00:29:58,630 So these are some types of joints. 335 00:29:58,940 --> 00:30:00,280 Those are inner join. 336 00:30:00,320 --> 00:30:08,000 So inner joints in the sense that the two days and the already displayed results, which are common 337 00:30:08,000 --> 00:30:09,020 in those tables. 338 00:30:09,170 --> 00:30:11,140 So what are the common in these two there? 339 00:30:11,150 --> 00:30:13,700 Was it one, two, three are in this table. 340 00:30:13,820 --> 00:30:17,250 And also I one, two, three are there in total. 341 00:30:17,600 --> 00:30:20,300 So all the disparate results, which are the commonality. 342 00:30:20,480 --> 00:30:23,420 So inner joint is like a intersection B. 343 00:30:27,410 --> 00:30:29,940 In Chinese intersection B. 344 00:30:40,250 --> 00:30:47,830 So I will show you what is here and what is being so fast, I want to see a select. 345 00:30:50,210 --> 00:30:51,500 A star from. 346 00:30:53,690 --> 00:30:58,160 For now, I want to apply, not join, I want to say. 347 00:31:00,180 --> 00:31:08,820 Inner join, I want to join in for table with Mark. 348 00:31:12,130 --> 00:31:20,080 And now I want to say on so on what basis, on what basis, your journey, these two tables on the Idy 349 00:31:20,080 --> 00:31:24,780 basis, I am joining these tables because the article is in this info in the box. 350 00:31:25,150 --> 00:31:26,380 So I will say. 351 00:31:28,870 --> 00:31:29,470 It's. 352 00:31:31,950 --> 00:31:39,720 So that's so you can you can access this table using the students that info and students dot marks, 353 00:31:40,500 --> 00:31:42,720 so it's students. 354 00:31:44,440 --> 00:31:56,410 Not in full or not, Heidi, you can access this individual column using the student database and enforce 355 00:31:56,410 --> 00:31:58,600 the will and the article is equal to. 356 00:32:00,790 --> 00:32:07,040 Students taught and marks, not I. 357 00:32:08,950 --> 00:32:18,460 So I am I want to join this info and the marks on the basis of this I.D. it makes good this. 358 00:32:23,250 --> 00:32:24,600 So I have some. 359 00:32:35,300 --> 00:32:36,320 Oh, I think I should. 360 00:32:48,460 --> 00:32:50,050 OK, students. 361 00:32:52,010 --> 00:32:52,960 So there you go. 362 00:32:53,010 --> 00:33:03,890 Yes, I got this what I have done is I said I want to order this from me for where I need to get all 363 00:33:03,890 --> 00:33:06,720 the resources that are matched with this marks. 364 00:33:06,890 --> 00:33:09,040 So what are the results that are my trademarks? 365 00:33:09,410 --> 00:33:11,020 On what basis it is? 366 00:33:11,020 --> 00:33:15,830 So I have only three ideas that are mentioned in this info table. 367 00:33:15,830 --> 00:33:17,960 And amongst those are three areas. 368 00:33:18,200 --> 00:33:21,290 And you can see the three and the first number on the phone number. 369 00:33:21,500 --> 00:33:29,990 And also I have joined the march to march here on the radar because this is a table we have as human 370 00:33:31,040 --> 00:33:32,600 left side and this is the right there. 371 00:33:32,600 --> 00:33:36,950 You can see this is these four sorry. 372 00:33:39,230 --> 00:33:44,780 So this these are not left in photos and this right. 373 00:33:45,230 --> 00:33:50,320 Uh, Tukaram Soldat, Mark's information can see it and the box. 374 00:33:50,930 --> 00:33:55,940 So this is a intersection B, so this is the year and this is the beat. 375 00:33:56,120 --> 00:34:02,370 So on intersexual we got only the matter is the are one, two, three. 376 00:34:03,140 --> 00:34:04,360 So this is a joint. 377 00:34:04,370 --> 00:34:05,370 I hope you have understood. 378 00:34:05,630 --> 00:34:07,040 Now let's see the left. 379 00:34:07,040 --> 00:34:07,850 The joint left. 380 00:34:14,500 --> 00:34:24,760 So what this does is it's like year on year when it's been union in the Section B. So what is that? 381 00:34:25,060 --> 00:34:32,350 What it does is it would display all of the info are the columns from the info table and also only the 382 00:34:32,740 --> 00:34:34,570 matching where you saw the marks. 383 00:34:34,580 --> 00:34:40,500 And if there are any that does not match, it will put the dollar values of I execute this. 384 00:34:41,530 --> 00:34:45,460 And as you can see, it displays are the columns from the info. 385 00:34:45,820 --> 00:34:47,820 There are the currents funding the info. 386 00:34:50,050 --> 00:34:52,020 And you can see there is a photo issues. 387 00:34:52,420 --> 00:34:55,140 But in this market, we do not have a default. 388 00:34:55,300 --> 00:34:56,300 We have the idea. 389 00:34:57,070 --> 00:34:59,200 So in this case, there is no default. 390 00:34:59,200 --> 00:35:01,030 That's where it has put the null values. 391 00:35:01,360 --> 00:35:07,420 So it is with all the value of here and only the matching value of being the so called innot left to 392 00:35:07,430 --> 00:35:07,740 join. 393 00:35:09,070 --> 00:35:17,980 And if I say right joint, so now you can get the right joint it displays are the values of these marks 394 00:35:18,220 --> 00:35:21,210 and only the matched results of this info. 395 00:35:21,370 --> 00:35:26,170 And if there are any leftovers from the info table, it will be replaced with another. 396 00:35:26,410 --> 00:35:29,860 So this is the joint if you change it to rejoin. 397 00:35:30,040 --> 00:35:38,130 Hourigan sees these values will be filled with data and the marks and these values internal to execute 398 00:35:38,140 --> 00:35:38,470 this. 399 00:35:46,420 --> 00:35:55,570 OK, now, if you can see these are the rules of these marks, they will have been successfully got 400 00:35:55,570 --> 00:36:02,110 and since there is no ideate in the info table, we got the Navajo's. 401 00:36:02,260 --> 00:36:06,370 So this is the right to only be and also match results from that. 402 00:36:06,370 --> 00:36:18,670 Yet it will be when you say intersection B minus the union intersection B, so there is a card for our 403 00:36:18,670 --> 00:36:22,450 joint which will combine every various. 404 00:36:26,240 --> 00:36:27,140 Squid, this. 405 00:36:32,830 --> 00:36:35,800 Ocurred, this is floatplane. 406 00:36:46,330 --> 00:36:50,260 OK, I don't know why I'm getting this are so full of. 407 00:36:51,920 --> 00:36:59,950 OK, if I run this floater, then I'll get that for Riley and also I'd already but in case it will join 408 00:36:59,950 --> 00:37:01,660 the whole left and right. 409 00:37:04,900 --> 00:37:06,940 So that's what this is called. 410 00:37:06,940 --> 00:37:07,630 Basic Search. 411 00:37:07,670 --> 00:37:14,460 I hope you have understood even I suggest you do practice all these statements. 412 00:37:14,470 --> 00:37:18,230 You can also Google them and practice the basic, uh, yes. 413 00:37:18,250 --> 00:37:19,060 Good qualities. 414 00:37:19,600 --> 00:37:25,350 And even those who do not practice just understand this video and it will be very much helpful. 415 00:37:25,940 --> 00:37:27,980 A further injection. 416 00:37:28,630 --> 00:37:33,850 You can do the manually, the you can join these tables and you can also union disturbers.