1 00:00:00,760 --> 00:00:07,480 In this video, we learn about two ways of creating tables in poverty and language for this in the poverty, 2 00:00:07,480 --> 00:00:07,960 Ed.. 3 00:00:08,440 --> 00:00:17,620 We need to right click and choose blank area and go to the advanced editor and we need to delete. 4 00:00:19,600 --> 00:00:24,520 And here we can write hash table. 5 00:00:27,400 --> 00:00:34,590 And parenthesis, and here we need to define the column headers, right? 6 00:00:36,130 --> 00:00:41,350 So the first hurdle will be a student named. 7 00:00:44,430 --> 00:00:46,710 And the second header will be. 8 00:00:48,810 --> 00:00:49,380 It. 9 00:00:51,520 --> 00:00:52,720 And the third will be. 10 00:00:56,560 --> 00:01:07,270 So this is the column header, right, and no need to put some record for each header, for each column, 11 00:01:08,230 --> 00:01:08,740 comma. 12 00:01:09,490 --> 00:01:14,970 And here we have to because all the records are our our list. 13 00:01:15,250 --> 00:01:18,190 So we need to put a list of lists here. 14 00:01:18,880 --> 00:01:20,800 So click it. 15 00:01:20,980 --> 00:01:30,040 And then again, calibur for the first list and it will be the student name is, for example, student 16 00:01:31,420 --> 00:01:37,390 one and the it is hash net. 17 00:01:38,080 --> 00:01:46,810 And here we have two right here, one nine nine zero comma zero one zero two. 18 00:01:47,410 --> 00:01:47,760 Right. 19 00:01:48,220 --> 00:01:57,940 And then we have to write the third parameter is possible 90 and in the same way, we can put one more 20 00:01:57,940 --> 00:01:59,350 record in the form of list. 21 00:01:59,770 --> 00:02:05,500 So we just need to copy comma and the second record. 22 00:02:06,700 --> 00:02:18,760 And this has to then to the date of parties to ninety two and the matter seventy five. 23 00:02:18,970 --> 00:02:25,990 So these are the two records because here we have defined the database structure and let's try to click 24 00:02:26,470 --> 00:02:26,860 that. 25 00:02:28,930 --> 00:02:39,580 So here you can see we can see these two records and we have to name age and the important thing to 26 00:02:39,580 --> 00:02:40,300 remember here. 27 00:02:40,540 --> 00:02:42,340 You can see here is the ABC. 28 00:02:42,340 --> 00:02:45,880 The tribe is like this is any typewrite. 29 00:02:46,090 --> 00:02:49,120 So like a text type ABC. 30 00:02:49,480 --> 00:02:50,200 One, two, three. 31 00:02:51,150 --> 00:02:56,550 So it it can hear like or the number or anything, right? 32 00:02:56,850 --> 00:03:00,330 So here you can see here we have a date. 33 00:03:00,840 --> 00:03:05,160 But the time this is is like a generic type. 34 00:03:05,680 --> 00:03:06,000 Right. 35 00:03:06,750 --> 00:03:11,250 And we can do, like, for example, a date. 36 00:03:12,390 --> 00:03:14,870 And for Dymocks, we can click here. 37 00:03:16,450 --> 00:03:16,810 No. 38 00:03:17,270 --> 00:03:26,910 So this is one way and not try to create one more Gyuri, so where we don't need to do these steps manually. 39 00:03:27,260 --> 00:03:28,360 So how we can do that? 40 00:03:29,180 --> 00:03:30,890 Let's go to this click. 41 00:03:33,910 --> 00:03:36,830 BlackBerry advance editor. 42 00:03:37,570 --> 00:03:40,930 And here we have to write. 43 00:03:43,830 --> 00:03:50,880 Let me throw it so here we have to right hash table. 44 00:03:55,200 --> 00:04:04,530 And then we have to declare the heretics firstly, we need to right here timetable. 45 00:04:12,340 --> 00:04:12,880 And. 46 00:04:19,080 --> 00:04:19,700 Peche. 47 00:04:23,420 --> 00:04:24,640 Student name 48 00:04:28,070 --> 00:04:37,370 is equal to what is the type of this caller, this is text like comma, then the second again, we need 49 00:04:37,370 --> 00:04:40,430 to write the second header for the date of birth. 50 00:04:41,300 --> 00:04:49,000 So it will be you'll be equal to date, the type up the date of birth column. 51 00:04:49,700 --> 00:04:53,120 Then the third one is hash. 52 00:04:55,250 --> 00:04:59,360 Mark's here we have to right, is equal to No. 53 00:05:02,820 --> 00:05:05,730 So this is the difference here. 54 00:05:05,760 --> 00:05:09,850 We have declared the column headers and there types. 55 00:05:10,530 --> 00:05:14,340 So we need to write a comma and no, again, the same stuff. 56 00:05:14,340 --> 00:05:20,650 We have to write here the list of lit to define the record. 57 00:05:21,360 --> 00:05:30,120 So this is the main list and it will contain two lists because we need to add records. 58 00:05:30,270 --> 00:05:31,980 So this is for the first list. 59 00:05:31,980 --> 00:05:34,400 We need to write here the first record. 60 00:05:35,010 --> 00:05:43,500 So the first value will be stored in one and then the date of birth. 61 00:05:43,890 --> 00:05:46,630 So hash it. 62 00:05:48,390 --> 00:05:52,500 So one nine nine zero comma zero one. 63 00:05:53,970 --> 00:06:00,790 Circle, and then the markets will be sold here. 64 00:06:00,840 --> 00:06:08,910 We can right here, 90 Karma can copy this are you can copy the complete list. 65 00:06:09,930 --> 00:06:15,130 And here we have two right here, comma and paste. 66 00:06:16,950 --> 00:06:18,420 So this is true, Rentoul. 67 00:06:21,290 --> 00:06:22,520 Date of birth is. 68 00:06:25,620 --> 00:06:26,340 93. 69 00:06:28,690 --> 00:06:33,220 And the marks are 80. 70 00:06:38,070 --> 00:06:47,010 So here you can see we are getting one indication of error, so we just we need to remove this comma 71 00:06:47,370 --> 00:06:51,650 and we also need to remove this because we don't need us here. 72 00:06:51,660 --> 00:06:53,860 It is the complete record. 73 00:06:54,690 --> 00:06:55,610 So that's all. 74 00:06:56,430 --> 00:06:59,760 And now we need to click that. 75 00:07:02,520 --> 00:07:08,220 And here you can see it's automatically fetch the right type. 76 00:07:08,380 --> 00:07:17,490 This is a tech site, this is the Bobbit and this one is like here you can see that this is the date, 77 00:07:18,100 --> 00:07:22,270 as you can see, the icon of the date and here of 1.0. 78 00:07:22,290 --> 00:07:25,860 This is the territory for the number four. 79 00:07:25,860 --> 00:07:30,330 In this way, you can create tables in power using M language.