INSERT INTO table
(column-1, column-2, ... column-n)
VALUES
(value-1, value-2, ... value-n);
Example 2:
INSERT INTO suppliers
(supplier_id, supplier_name)
VALUES
(24553, 'IBM');
Example 3:
INSERT INTO suppliers
(supplier_id, supplier_name)
SELECT account_no, name
FROM customers
WHERE city = 'Newark';