MySql Insert Multiple

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

?>



Coding Tag

Coding Tag always happy to serve you in Information Technology (IT). Learn HTML, CSS, Javascript, PHP, Android, Digital Marketing, Latest IT News and many more.

Leave a Reply

avatar
  Subscribe  
Notify of