We can insert multiple records into a table at once using the insert multiple query function start by
creating as many insert into statements is needed
in this example.
We'll be inserting three records so we we've created three insert statements notice that the second
and third Pascual variables have a period in front of the equals sign.
This is necessary for each additional record you want to add after the first one.
Next we create an if statement set to execute the multiple query function on our Eskew will statements
if the records were inserted successfully a message is output it it will state that the new records
were created let's test our script by running the script in our web browser.
So to do that just type in the world to the script in your address bar and present your And so you should
see the success message and we'll confirm that the records were inserted.
By refreshing our users table in the my Web site database
and so we can see that the three names Neal Jennings Judy Lam and Justin Lee were inserted into the
database.