how to insert multiple rows in phpmyadmin for testing code example
Example: mysql best way to insert many rows
INSERT INTO table_name(id,colname) values(1,"row 1"),(2, "row 2"),...;
INSERT INTO table_name(id,colname) values(1,"row 1"),(2, "row 2"),...;