Use a single `INSERT INTO` statement with multiple `VALUES` rows
Syntax: `INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4), (value5, value6);`
Omit the column list only if inserting values for all columns in the exact table order
Ensure each row has the same number of values as the listed columns
Use `INSERT INTO … SELECT` to insert multiple rows from another table or query
Use `UNION ALL` with `SELECT` when needed to combine multiple source rows
Use transactions for large inserts to improve consistency and rollback control
Batch large inserts into smaller groups to reduce locking and memory usage
Use parameterized queries or prepared statements for repeated multi-row inserts
Validate data types, constraints, and defaults before inserting multiple records