We can execute as you will statements to our my high school database through P HP my admin.
Remember that most of the actions we perform right through the g y translate into escudos statements
automatically.
Let's take a look at an example of that in action expand the Mind website database and click on the
user's table
just by clicking on the user's table.
P p my admin is automatically executed Eskew WILL SELECT statement is seen here
the Eskew WILL SELECT statement retrieves records from a table within a specified database.
In this case the table is users
we currently have two records in this table let's add another record and see the Eskimo statements that
are generated click on the Insert button to add a record
we can see that by inserting a record another as your statement was automatically relayed to our my
school database this time it was an insert into statement
Don't worry about this in text for now it's just important to understand that almost every action we
perform in my admin sends a set of instructions to our my askew old database
now let's do the same thing we just did except this time will manually type out the escudos syntax in
the Eskew will Ed so click on Eskew Well let's start by creating and ask Will statement that selects
all the records in our users table and displays them this is fairly simple we just need to delete this
part of the statement so it should read.
Select and then the asterisks which is symbol for records from users so select records from users and
you can see that it's retrieved all the records that are in this table
now Let's insert a record into our database through the Eskew you'll Ed and for this we'll be using
the insert into statement so just highlight this text and type in this statement so insert into table
users and with the insert statement we need to specify the column headings so I D.
First Name Last Name Email in date
and in the corresponding values that we want to insert into these fields so leave the first the first
value empty inside the single quotes.
That's because the up the idea value is automatically created for us.
And same with date
so the only values we need to specify is the first name.
The last name in the first and last values are automatic.
So just leave them empty
so once you've finished your insert statement click go and you'll see that we have a success message.
That means that the statement was executed successfully and to confirm that we'll click on browse and
we can see that that the entry was inserted.