Insert multiple

This is basically the same insert idea as before, just stretched to more than one row at once.

Instead of sending one INSERT INTO ... VALUES (...) for a single record, you can send one insert statement with multiple value groups. Each pair of parentheses represents one row, and the groups are separated by commas.

So the shape becomes: same table, same columns, multiple rows in one command.

The useful idea here is that one SQL statement can add several records at once. That can be more convenient than writing separate insert statements one by one. In the MySQLi example, they use multi_query(), but the real thing to notice is not just the method name – it is that the SQL string contains multiple row value sets in a single insert operation.

For your current stage, the main concept is simple: one insert can create several new rows, as long as the columns stay the same and each row provides values in the same order.