How to Insert Data in MySQL

Last updated July 24, 2026 · By the SaturnSQL team

Use INSERT INTO ... VALUES with one or many row tuples, or INSERT ... SELECT to copy query results. Multi-row inserts are much faster than one INSERT per row.

INSERT INTO orders (customer_id, amount)
VALUES (101, 42.50), (102, 17.00);

INSERT INTO orders_archive
SELECT * FROM orders WHERE created_at < '2025-01-01';