INSERT INTO table_name [ ( column_name [, ...] ) ]
{ VALUES ( expression [, ...] ) [, ...] | query }

INSERT INTO table_name [ ( column_name [, ...] ) ]
{ VALUES ( expression [, ...] ) [, ...] | query }

+-------+
| count |
+-------+
| 1     |
+-------+

+-------+
| count |
+-------+
| 1     |
+-------+

+-------+
| count |
+-------+
| 3     |
+-------+

+-------+
| count |
+-------+
| 3     |
+-------+

INSERT INTO customers (id, name, email)
VALUES (1, 'Alice Smith', 'alice@example.com');

INSERT INTO customers (id, name, email)
VALUES (1, 'Alice Smith', 'alice@example.com');

INSERT INTO customers (id, name, email)
VALUES 
  (2, 'Bob Johnson', 'bob@example.com'),
  (3, 'Carol Wilson', 'carol@example.com'),
  (4, 'David Brown', 'david@example.com');

INSERT INTO customers (id, name, email)
VALUES 
  (2, 'Bob Johnson', 'bob@example.com'),
  (3, 'Carol Wilson', 'carol@example.com'),
  (4, 'David Brown', 'david@example.com');

INSERT INTO products 
VALUES (101, 'Laptop', 999.99, 'Electronics');

INSERT INTO products 
VALUES (101, 'Laptop', 999.99, 'Electronics');

INSERT INTO archive_orders (order_id, customer_id, total, order_date)
SELECT order_id, customer_id, total, order_date
FROM orders
WHERE order_date < '2024-01-01';

INSERT INTO archive_orders (order_id, customer_id, total, order_date)
SELECT order_id, customer_id, total, order_date
FROM orders
WHERE order_date < '2024-01-01';