MySQL Insert Multiple

by Yogesh Khanna 15-Jun-16

0 722


MySql Insert Multiple

You can also insert multiple values in the table at a time.

For Example:
<?php

$query="INSERT INTO students(name,email_id,city) VALUES
('Vihaan','vihaan@codingtag.com','Delhi'),
('Manisha','manisha@codingtag.com','New Delhi'),
('Ankita Sharma','ankita@codingtag.com','New Delhi')";

if($query)
{
echo "New Multiple Values Inserted Successfully";
}
else
{
echo "Error occurred";
}

?>

Share:

Comments

    No Comments Yet.

Leave a Reply