insert into many values mysql code example

Example 1: mysql best way to insert many rows

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

Example 2: insert multiple items in mysql

#Assuming that there is a database called MyDatabase
#The following adds items to a table called TableName with columns No., Age, and class
use MyDatabase;
insert into TableName(No., Name, Age, Class)
values(1, "VinCoD", 21, "4E");