Let us put some more data into the table.
We are going to enter five more records, insert into salary values that mean employ 102.
department in sales salary is 25000.
Then we are going to enter information 103 employ, 104, 105 and
106.
Then, when we have entered the data, we are going to perform the query select * from salary.
It is going to show us all the six records after viewing the records.
We are going to quit because then we want to fetch the data, not by this query, by using php application.
So now let us insert some other data into our MySQL database so we will clear the screen.
So we are going to make entries.
So here the second record is your employee number is 102, department is sales, then the salary
we are going to specify, as we have discussed.
25000.
So that is the second record we are going to make entry then we are going to enter the third record,
the department is production.
So we are going to specify.
Production, that means we are entering some data.
So we are specifying any, you can put any values for, we are just creating one simple database, then
we are going to make entries regarding your this fourth record, then we are going to specify the department
as.
CS and we are going to show the Salary as enter field 20000.
We are going to enter the fourth record, fifth record.
Employee number is five, department is again CS here, we are going to specify.
That mean we are entering the data, as we have discussed now one another entry that is.
Six department is IT.
And we are specifying the pay as 90000.
So that means we have entered now total 6 records, how you are going to verify, how you are going to perform
the query that is select * from which table salary.
So that is what it is showing you, let us clear the screen that this is the query.
after that, we are going to quit.
That means now we have created a database in that we have created one table and put some data.
Now our requirement is we do not want to use this type of query select *.
We want to use php application for ffetching the data.
So that will show us the link between Apache, MySQL and PHP.
And because all of this is working on our Linux system, that will be the example of your Lamp Stack.