1
00:00:00,660 --> 00:00:01,480
Hello, everyone.

2
00:00:01,770 --> 00:00:07,160
In the last video, I have shown you how you can create a table inside that database.

3
00:00:07,560 --> 00:00:13,460
Now I will show you how you can put the data inside this table, which means inside the database.

4
00:00:13,860 --> 00:00:19,800
So the first thing that you have to know to know that we have I told you about this line because we

5
00:00:19,800 --> 00:00:22,670
are we have already created this database.

6
00:00:22,680 --> 00:00:25,230
So in this line, we just connected.

7
00:00:25,710 --> 00:00:28,800
Then in this line, we have created this line.

8
00:00:28,800 --> 00:00:30,000
We have created the cursor.

9
00:00:30,420 --> 00:00:32,640
And in this line we have created the table.

10
00:00:32,730 --> 00:00:40,050
But we put it we put this line, this line in the comments because we don't want to create another table

11
00:00:40,050 --> 00:00:41,630
with the same name users.

12
00:00:42,510 --> 00:00:47,990
Now, as I told you, we want to fill this table with data.

13
00:00:48,000 --> 00:00:49,620
For example, this is our table.

14
00:00:49,830 --> 00:00:54,450
We have this line first night, first name or last name and age.

15
00:00:54,640 --> 00:00:59,280
So we would, for example, these two users and we can use we can add another one.

16
00:01:00,540 --> 00:01:04,860
So the first thing that you have to know that we will use the same function, which is execute.

17
00:01:05,220 --> 00:01:13,550
We have just to change this keyword because this key will create table is special for creating a table.

18
00:01:13,560 --> 00:01:18,690
No one will enter some data into the database.

19
00:01:18,900 --> 00:01:20,310
So we will use it now.

20
00:01:20,580 --> 00:01:28,590
So same thing we call the cursor that's executed and here we will make like a screen.

21
00:01:28,800 --> 00:01:37,740
So we will create will rise, as I told you, insert into insert something into that.

22
00:01:37,740 --> 00:01:44,450
Here we will write the name of the table that we have, which is users, users.

23
00:01:44,820 --> 00:01:47,970
After that, we will write value values.

24
00:01:47,970 --> 00:01:55,890
Sorry, because we want there is some value that we want to put it inside the table or inside the database.

25
00:01:56,220 --> 00:02:00,810
So here we have the into values.

26
00:02:01,110 --> 00:02:05,700
Here we have to open the parenthesis and inside dependencies.

27
00:02:05,700 --> 00:02:07,850
We write the values that we want to put.

28
00:02:08,250 --> 00:02:10,560
So we will give its names here.

29
00:02:10,560 --> 00:02:17,280
These names, we have to put it in order to have the first name, then the last name at that age.

30
00:02:17,500 --> 00:02:24,330
So we will create three variables that will have the role of the first name and last name and age in

31
00:02:24,330 --> 00:02:26,370
this order against the audience.

32
00:02:26,620 --> 00:02:31,380
OK, so here we will make the first day, really give it the same name.

33
00:02:31,390 --> 00:02:37,830
So we have to write columns, the first name, for example, first name or we can we can change this.

34
00:02:37,830 --> 00:02:43,660
We can make another name of anyone, but we will we will keep it to make it more clear.

35
00:02:44,040 --> 00:02:45,330
So then come on then.

36
00:02:45,330 --> 00:02:47,790
Second one is last name.

37
00:02:49,470 --> 00:02:53,310
Then the third one is each column, then each.

38
00:02:53,640 --> 00:03:02,790
So if we put a variable or a value in this value, because this, this, this, this line means that

39
00:03:03,060 --> 00:03:10,980
the values of first name and last name and age, we were inserted into the table, which is use it,

40
00:03:11,280 --> 00:03:16,670
which means that we will take this value and put it in the user name insert name here.

41
00:03:17,130 --> 00:03:23,620
Then we will take the last name here and put it in this column, then the same thing.

42
00:03:24,030 --> 00:03:31,380
So what we have to do now, we have just to make the to enter the variables or the values that we want

43
00:03:31,380 --> 00:03:33,920
to make in the database.

44
00:03:34,260 --> 00:03:35,490
So we may come up here.

45
00:03:36,570 --> 00:03:40,030
I will make I will go to a new line to make it more clear.

46
00:03:40,530 --> 00:03:48,380
So to enter the data in into these values, we have to open this brackets inside the brackets.

47
00:03:48,390 --> 00:03:49,650
We will give the variables.

48
00:03:50,050 --> 00:03:57,330
For example, we have here the first the first column that we have, which is first name, first name,

49
00:03:57,780 --> 00:03:59,460
then this.

50
00:03:59,940 --> 00:04:04,440
But this variable will take the value, for example, we will give it as we have here.

51
00:04:04,950 --> 00:04:12,420
We had the first user, which is Mukti, I mean, and 24 years old.

52
00:04:12,570 --> 00:04:13,800
So we will give it here.

53
00:04:13,800 --> 00:04:18,230
The first name, first name here, give it as string.

54
00:04:18,230 --> 00:04:26,040
So I would give it like this three, then the last name to go.

55
00:04:26,050 --> 00:04:34,080
The next line we have to make up that we have we go to the next line, which is last name.

56
00:04:35,610 --> 00:04:38,640
Then we will you make Cullum's then.

57
00:04:38,640 --> 00:04:44,160
Here the value is, I mean then we will make it come up to go to the next line.

58
00:04:44,160 --> 00:04:48,350
Then here we have each which is the value for example.

59
00:04:48,360 --> 00:04:52,530
Twenty four and we have this is, this is the last line.

60
00:04:52,830 --> 00:04:55,260
So we want to add come here.

61
00:04:55,380 --> 00:04:58,380
We have to make if we want to go to another line.

62
00:04:58,380 --> 00:04:59,440
But if it is.

63
00:04:59,800 --> 00:05:06,730
Last night, we were just like this, so if we get on our program, we see that there is no errors,

64
00:05:06,730 --> 00:05:11,170
which means that this data is all it works, which means that works.

65
00:05:11,350 --> 00:05:17,620
If we want to enter another another data, if we run this program another time, we wait until this

66
00:05:17,620 --> 00:05:19,690
user second or second time.

67
00:05:20,620 --> 00:05:25,870
And then if we run it another time when we have three users with the same last name and first name and

68
00:05:25,870 --> 00:05:26,910
age, etc..

69
00:05:27,280 --> 00:05:33,890
Now, if we want to make to enter another user, just we have just to change this one first name, the

70
00:05:33,910 --> 00:05:35,010
last name and age.

71
00:05:35,230 --> 00:05:41,650
Every time we change this, we will have a new user and we have new line in our our table, which is

72
00:05:41,650 --> 00:05:42,490
in the database.

73
00:05:42,730 --> 00:05:48,940
So we have the first when we run the first time with the first values we will have here, the first

74
00:05:48,940 --> 00:05:56,680
user, the second if we change it here, for example, the second time we will make it here, I forget,

75
00:05:56,830 --> 00:05:58,390
which is Legian.

76
00:05:58,660 --> 00:06:10,040
So we make it here, Lee and John, which has twenty two years on this one.

77
00:06:10,240 --> 00:06:18,790
So if we are on our program now, we will have this new user in New Line, which is Legia, which we

78
00:06:18,790 --> 00:06:20,580
are 22 years old.

79
00:06:21,160 --> 00:06:23,350
So that's what's for today.

80
00:06:23,480 --> 00:06:28,860
I have shown you how you can enter or insert the data into your database.

81
00:06:29,200 --> 00:06:34,360
In the next video, I will show you how you can return it or take it out and print it or do something

82
00:06:34,360 --> 00:06:34,700
with it.

83
00:06:35,200 --> 00:06:38,120
So thanks for watching and I'll see you in the next video.

84
00:06:38,380 --> 00:06:39,850
And stay safe by.