Insert multiple rows into mysqlsql statements

Normally, we use SQL to execute INSERTINTO 'tabale '('name') VALUE (name). If php needs to execute such SQL statements cyclically, therefore, execute an SQL statement below to insert multiple rows of records. INSERTINTO 'tabale '('name') VALUE (name), (name) How many pieces of data are inserted at a time. Original

Normally, we use SQL to execute insert into 'tabale '('name') VALUE (name). If php needs to execute such SQL statements cyclically, therefore, execute an SQL statement below to insert multiple rows of records. Insert into 'tabale '('name') VALUE (name), (name) How many pieces of data are inserted at a time. Original

Normally, we use SQL to execute INSERT INTO 'tabale '('name') VALUE ('name ')

If you want to use php to execute such an SQL statement, you need to execute the following SQL statement to insert multiple rows of records.

Insert into 'tabale '('name') VALUE ('name'), ('name ')

You want to insert more than one entry at a time.

Original article address: insert multiple rows of records into mysql SQL statements. Thanks to the original author for sharing.