mysql best way to insert many rows
snippet in sql

mysql best way to insert many rows

user2649

INSERT INTO table_name(id,colname) values(1,"row 1"),(2, "row 2"),...;