1
00:00:00,060 --> 00:00:02,410
Let us put some more data into the table.

2
00:00:02,430 --> 00:00:09,570
We are going to enter five more records, insert into salary values that mean employ 102.

3
00:00:09,840 --> 00:00:12,450
department in sales salary is 25000.

4
00:00:12,450 --> 00:00:19,530
Then we are going to enter information 103 employ, 104, 105 and

5
00:00:20,370 --> 00:00:20,810
106.

6
00:00:21,210 --> 00:00:27,990
Then, when we have entered the data, we are going to perform the query select * from salary.

7
00:00:28,200 --> 00:00:32,760
It is going to show us all the six records after viewing the records.

8
00:00:32,760 --> 00:00:40,240
We are going to quit because then we want to fetch the data, not by this query, by using php application.

9
00:00:40,740 --> 00:00:48,930
So now let us insert some other data into our MySQL database so we will clear the screen.

10
00:00:49,470 --> 00:00:51,620
So we are going to make entries.

11
00:00:52,170 --> 00:01:06,090
So here the second record is your employee number is 102, department is sales, then the salary

12
00:01:06,090 --> 00:01:08,460
we are going to specify, as we have discussed.

13
00:01:09,300 --> 00:01:09,990
25000.

14
00:01:12,640 --> 00:01:19,680
So that is the second record we are going to make entry then we are going to enter the third record,

15
00:01:20,350 --> 00:01:22,950
the department is production.

16
00:01:23,740 --> 00:01:25,240
So we are going to specify.

17
00:01:26,920 --> 00:01:29,640
Production, that means we are entering some data.

18
00:01:31,080 --> 00:01:41,100
So we are specifying any, you can put any values for, we are just creating one simple database, then

19
00:01:41,100 --> 00:01:50,740
we are going to make entries regarding your this fourth record, then we are going to specify the department

20
00:01:50,760 --> 00:01:51,000
as.

21
00:01:53,250 --> 00:02:01,590
CS and we are going to show the Salary as enter field 20000.

22
00:02:05,700 --> 00:02:09,180
We are going to enter the fourth record, fifth record.

23
00:02:12,130 --> 00:02:18,010
Employee number is five, department is again CS here, we are going to specify.

24
00:02:19,250 --> 00:02:25,580
That mean we are entering the data, as we have discussed now one another entry that is.

25
00:02:27,210 --> 00:02:30,740
Six department is IT.

26
00:02:32,600 --> 00:02:35,330
And we are specifying the pay as 90000.

27
00:02:38,030 --> 00:02:48,170
So that means we have entered now total 6 records, how you are going to verify, how you are going to perform

28
00:02:48,170 --> 00:02:55,970
the query that is select * from which table salary.

29
00:02:58,870 --> 00:03:04,770
So that is what it is showing you, let us clear the screen that this is the query.

30
00:03:06,130 --> 00:03:08,020
after that, we are going to quit.

31
00:03:09,670 --> 00:03:14,860
That means now we have created a database in that we have created one table and put some data.

32
00:03:15,520 --> 00:03:20,610
Now our requirement is we do not want to use this type of query select *.

33
00:03:20,920 --> 00:03:25,190
We want to use php application for ffetching the data.

34
00:03:25,660 --> 00:03:31,810
So that will show us the link between Apache, MySQL and PHP.

35
00:03:32,140 --> 00:03:38,530
And because all of this is working on our Linux system, that will be the example of your Lamp Stack.