1
00:00:00,330 --> 00:00:07,290
Now we are going to create one simple data in one simple table with the command create table salary.

2
00:00:07,920 --> 00:00:10,860
We want to have three fields there employ number.

3
00:00:11,130 --> 00:00:17,970
we are saying that type of that field is char three.

4
00:00:18,450 --> 00:00:20,810
Then we are specifying it is the primary key.

5
00:00:21,420 --> 00:00:26,430
Then we are specifying that department as a varchar type of 15.

6
00:00:26,430 --> 00:00:26,760
character.

7
00:00:26,940 --> 00:00:33,210
Then salary we are specifying salary of int six type, then we are going to close, it is going to create

8
00:00:33,210 --> 00:00:33,900
the tables.

9
00:00:33,900 --> 00:00:35,040
We can verify this.

10
00:00:35,040 --> 00:00:36,840
by using that command show tables.

11
00:00:37,020 --> 00:00:39,420
It will show us the table salary.

12
00:00:39,720 --> 00:00:45,170
Then we are going to first enter one record into this, how to enter the record that mean

13
00:00:45,180 --> 00:00:54,930
insert into salary values that when we are going to enter a values there, that the employee number

14
00:00:55,620 --> 00:01:01,950
and what is the department, we are going to say, the marketing department then we are going to

15
00:01:01,950 --> 00:01:03,500
enter the salary.

16
00:01:03,810 --> 00:01:08,970
So let us first create the table and then put some data into there, then in next.

17
00:01:08,970 --> 00:01:12,130
videos We further we are going to put a lot more data.

18
00:01:12,150 --> 00:01:14,190
So let us first create a simple table.

19
00:01:14,610 --> 00:01:22,220
So we have already connected to our mariadb server by using this aanya user.

20
00:01:22,230 --> 00:01:23,810
So I will clear the screen.

21
00:01:24,450 --> 00:01:31,440
So what we are going to do create table salary.

22
00:01:34,190 --> 00:01:36,070
So bracket start.

23
00:01:37,800 --> 00:01:45,050
Then we are going to specify the field, eno it is going to be of type char in your case so

24
00:01:45,060 --> 00:01:47,200
you can create complex databases.

25
00:01:47,490 --> 00:01:49,570
We wanted to keep the things simple.

26
00:01:50,520 --> 00:01:55,520
So we are going to specify this as primary key.

27
00:01:57,750 --> 00:02:07,110
And then comma, the second field is going to be department, it is going to be of varchar type and we are going

28
00:02:07,110 --> 00:02:09,840
to specify that it will be of.

29
00:02:10,850 --> 00:02:11,810
length 15.

30
00:02:13,140 --> 00:02:21,270
Then we are going to specify the comma, then we have salary, how much salary the employee has got.

31
00:02:24,510 --> 00:02:26,370
So we want it to be of.

32
00:02:30,360 --> 00:02:30,840
six digit.

33
00:02:31,930 --> 00:02:34,480
And we are going to close this.

34
00:02:37,310 --> 00:02:44,930
Now, this table got created, so how we are going to view this table so we can run that command

35
00:02:44,960 --> 00:02:48,790
show tables command it is showing you the salary table is there.

36
00:02:49,220 --> 00:02:57,810
Now, what we are going to do, we are going to insert some data, insert into which table, salary 

37
00:02:57,830 --> 00:03:00,680
table values.

38
00:03:00,680 --> 00:03:01,790
What are the values?

39
00:03:03,470 --> 00:03:06,230
So we will enter the values.

40
00:03:07,920 --> 00:03:09,720
101 is the employee number.

41
00:03:11,120 --> 00:03:12,950
And department is.

42
00:03:14,580 --> 00:03:15,210
Marketing.

43
00:03:18,640 --> 00:03:26,920
then we are going to specify the salary, 30000, you can enter any

44
00:03:26,920 --> 00:03:27,850
value you want.

45
00:03:29,950 --> 00:03:39,100
That mean we are able to enter the one value into that, so our table creation is successful.