1 00:00:01,260 --> 00:00:05,640 So now, as you can see, the database has been created, make sure that the database here is listed 2 00:00:05,640 --> 00:00:07,560 among your databases. 3 00:00:08,280 --> 00:00:12,780 And then now what you need to do is that we need to create the first table here. 4 00:00:12,780 --> 00:00:17,550 If you select the Python database, it's going to say, you know, tables found in database. 5 00:00:17,700 --> 00:00:19,770 That's because we don't have any tables yet. 6 00:00:20,370 --> 00:00:21,510 So let's see at the table. 7 00:00:22,050 --> 00:00:26,730 In order to give you the table, you need to select the database and then you need to type the name 8 00:00:26,730 --> 00:00:27,300 of the table. 9 00:00:27,750 --> 00:00:34,110 So in the name of the table, in my project, I'm going to name it movies because this is obviously 10 00:00:34,740 --> 00:00:35,790 a movies table. 11 00:00:36,390 --> 00:00:38,460 And then we need for this table. 12 00:00:38,460 --> 00:00:41,760 We need we need three columns. 13 00:00:41,760 --> 00:00:45,570 We need a column for the the ID of the movie. 14 00:00:45,960 --> 00:00:51,000 We need a column for the title and we need a column for the year. 15 00:00:51,750 --> 00:00:57,480 And we can also add another column for something else, such as the description. 16 00:00:57,750 --> 00:00:59,120 Maybe the storyline? 17 00:00:59,130 --> 00:01:00,240 Let's save a story line. 18 00:01:00,690 --> 00:01:05,250 So let's say for I'm going to say four and then I'm going to click on going. 19 00:01:07,320 --> 00:01:12,840 Now for this, we need to fill this table up with the columns that we want. 20 00:01:13,380 --> 00:01:16,880 So the first column is the idea, the idea. 21 00:01:16,920 --> 00:01:19,240 We need to say it because each movie must have an ID. 22 00:01:20,040 --> 00:01:22,940 The ID, the type is integer, the length. 23 00:01:22,950 --> 00:01:25,950 I'm going to say it live in the default. 24 00:01:26,220 --> 00:01:27,190 We can't. 25 00:01:27,240 --> 00:01:28,590 We need to keep it non here. 26 00:01:29,340 --> 00:01:32,730 The I, the auto increment must be checked. 27 00:01:32,730 --> 00:01:36,870 You need to check this and you make sure that it says here primary. 28 00:01:37,410 --> 00:01:38,700 This is very, very important. 29 00:01:39,060 --> 00:01:40,950 The ID must be the primary key. 30 00:01:42,570 --> 00:01:47,790 Now, let's move on to the second column of the second column is the title I'm going to say title. 31 00:01:48,570 --> 00:01:50,550 The title is going to be VAKA. 32 00:01:51,830 --> 00:01:57,110 And the value will be, let's say, two hundred fifty five, and that's it. 33 00:01:57,950 --> 00:02:05,840 Next, we need to specify the year we need to say a year for the year column and for the year it can 34 00:02:05,840 --> 00:02:06,530 be integer. 35 00:02:06,530 --> 00:02:07,330 It can lead eight. 36 00:02:07,760 --> 00:02:08,690 It can be text. 37 00:02:09,200 --> 00:02:14,690 But instead of using dates, if you use that, you would have to provide the complete date. 38 00:02:15,320 --> 00:02:17,210 And they don't want to provide a complete date. 39 00:02:17,210 --> 00:02:20,570 Instead, I just want the year, which is four digits. 40 00:02:20,690 --> 00:02:21,920 Therefore, I'm going to say text. 41 00:02:22,310 --> 00:02:28,520 You can just simply say text because there is no need to provide the complete date because most movies 42 00:02:29,390 --> 00:02:34,550 don't specify, don't say the complete date, the exact day and month. 43 00:02:34,910 --> 00:02:36,260 They just provide the year. 44 00:02:36,380 --> 00:02:38,180 Therefore, I'm going to say you text. 45 00:02:38,840 --> 00:02:46,400 The last column is the story line, story line, and the story line is going to be text because the 46 00:02:46,400 --> 00:02:51,560 story line is going to be a longer than the the title. 47 00:02:51,570 --> 00:02:53,240 So therefore I'm going to say text. 48 00:02:54,020 --> 00:02:57,500 And lastly, once you are done, you need to click on see. 49 00:02:58,010 --> 00:02:59,180 You need to click on Save. 50 00:02:59,210 --> 00:03:06,260 However, before I click on Save the Story line can be now longer, I'm going to say no, because sometimes 51 00:03:06,260 --> 00:03:06,800 you might. 52 00:03:07,100 --> 00:03:09,640 You might not want to provide the storyline. 53 00:03:09,650 --> 00:03:12,290 The storyline is just an additional field. 54 00:03:13,340 --> 00:03:16,520 The most important things are the title of the year. 55 00:03:16,760 --> 00:03:22,700 The story line is just an extra field that you sometimes you might want to provide it. 56 00:03:22,970 --> 00:03:25,190 And sometimes you might want to keep it empty. 57 00:03:25,580 --> 00:03:27,500 Therefore, you can say here No. 58 00:03:28,100 --> 00:03:29,840 And once you are done, click on Save. 59 00:03:30,620 --> 00:03:36,440 And if you click on Save, you will find that a new table has been created and it has these four columns 60 00:03:37,040 --> 00:03:41,540 and make sure before you do anything, you need to make sure that everything is correct. 61 00:03:42,050 --> 00:03:48,530 Make sure that the idea here there is a key being displayed next to the edit and make sure that it's 62 00:03:48,530 --> 00:03:50,690 auto increment the title. 63 00:03:50,750 --> 00:03:55,650 Make sure that it's marker two hundred fifty five the year and make sure it's six. 64 00:03:55,800 --> 00:03:56,480 The storyline? 65 00:03:56,480 --> 00:04:03,050 Make sure it sticks and make sure that the story line is no longer the default value is no. 66 00:04:03,320 --> 00:04:06,770 And make sure that they know here is yes for the story line. 67 00:04:09,070 --> 00:04:12,310 And now we have a table called Wooden's.