You want to add multiple data/value/row in single time than follow this syntax
Syntax:-
INSERT INTO table_name (col_name1, col_name2,...col_namen) VALUES (col_name1_data1,col_name2_data1,....col_namen_data1),(col_name1_data2,col_name2_data2,....col_namen_data2),....(col_name1_datan,col_name2_datan,....col_namen_datan);
Note:-
# Any number of row can be added.
# Order of data/values must match order of column name.
Example:-
Here we adding 3 row to homedetails table
INSERT INTO homedetails (homeno,homename,state,country) VALUES(206,"chiguru",”karnataka”,”india”),(20,"guru",”kerala”,”india”),(28,"krish",”goa”,”india”);
Syntax:-
INSERT INTO table_name (col_name1, col_name2,...col_namen) VALUES (col_name1_data1,col_name2_data1,....col_namen_data1),(col_name1_data2,col_name2_data2,....col_namen_data2),....(col_name1_datan,col_name2_datan,....col_namen_datan);
Note:-
# Any number of row can be added.
# Order of data/values must match order of column name.
Example:-
Here we adding 3 row to homedetails table
INSERT INTO homedetails (homeno,homename,state,country) VALUES(206,"chiguru",”karnataka”,”india”),(20,"guru",”kerala”,”india”),(28,"krish",”goa”,”india”);
homeno | homename | state | country |
206 | chiguru | karnataka | india |
20 | guru | kerala | india |
28 | krish | goa | India |
Leave reply
Add your comments here