Insert Multiple Rows (Records) in database

 INSERT INTO table_name(column1, column2, column3...) VALUES(value1, value2, value3...),

(value1, value2, value3...), (value1, value2, value3...), (value1, value2, value3...);

For Example: For Table personal,

INSERT INTO personal(id, name, birth_date, phone, gender)

 VALUES

(1, "Amar", "2002-10-22", "9655247781", "M"),

(2, "Meera Khan", "2000-09-11", "8566321190", "F"),

(3, "Ajay Patel", "2001-07-22", "9633258874", "M");

Comments

Post a Comment

Popular posts from this blog

Logical_Operators

  <?php     $age = 20 ;     $age1 = 25 ;     if ( $age >= 18 && $age <= 21 )     {         echo "You are Eligible<br>" ;     }         if ( $age >= 18 || $age <= 21 )     {         echo "You are Eligible<br>" ;     }     //Below condition is True So that "Not Operator(!)" will return False condition     if (!( $age >= 18 ))     {         echo "You are Eligible<br>" ;     }     //Below condition is False So that "Not Operator(!)" will return True condition     if (!( $age <= 18 ))     {         echo "You are Eligible<br>" ;     }     //If both condition is "True" OR "False" at that time xor will return "False" and if one condition is     //"True" and s...
Read more

Get Functions

  <?php //There are many Get Functions in PHP as shown below: //get_class, get_parent_class, get_class_methods, get_class_vars, get_object_vars, get_called_class, //get_declared_classes, get_declared_interfaces, get_declared_traits, class_alias class ParentClass {     function name ()     {         echo "Class Name : " . get_class ( $this ) . "<br>" ;   //Print the particualr Class Name         //Print the particular Parent Class Name as shown below:         echo "Parent Class Name : " . get_parent_class ( $this ) . "<br>" ;     } } class ChildClass extends ParentClass {     function __construct ()     {}     function myfunction ()     {}     function myfunction2 ()     {} } $obj = new ChildClass (); $obj -> name (); echo "Class Name is : " . get_class ( $obj ) . "<br>" ; echo "Paren...
Read more

print_Statement

  <?php     echo "Hello, Welcome Everyone" ;     echo "<b>Hello" , "World</b>" ;     echo "<h1>Hello" . " brother</h1>" ;     echo "<h1><i>Let's" . " come</i></h1>" ;     echo 2364789 ;     echo 43.98 ; //  OUTPUT: // Hello, Welcome EveryoneHelloWorld // Hello brother // Let's come // 236478943.98 Hello World ? > < html >     < head >         < title > PHP </ title >     < head >     < body >         <?php             echo "Hello World" ;         ? >     </ body > </ html >
Read more