MySQL Insert Multiple

0 4555

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";
}

?>