MySQL Insert Multiple Values | How MySQL works
×

MySQL Insert Multiple

3366

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

?>



Best WordPress Hosting


Share:


Discount Coupons

Get a .COM for just $6.98

Secure Domain for a Mini Price



Leave a Reply


Comments
    Waiting for your comments