Create several rows in one statement.
Section: insert, update, and delete
Insert multiple rows
sql
sql
INSERT INTO users (email, full_name) VALUES
('liam@example.com', 'Liam Cole'),
('mia@example.com', 'Mia Shaw');Explanation
Batch inserts reduce round trips and are often much faster than many single-row statements.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing insert, update, and delete
Truncate a table
Remove all rows quickly and reset auto-increment counters.
Upsert with ON DUPLICATE KEY UPDATE
Insert a row or update it when a unique key already exists.
Replace a row using REPLACE
Insert or delete-and-insert based on unique key conflicts.