How to Insert Multiple Rows in Mysql with example

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”);

homeno	homename	state	country
206	chiguru	karnataka	india
20	guru	kerala	india
28	krish	goa	India

Previous Code:-
Update data in tables

List Code:-
Mysql Codes

Next Code:-
Delete row