Category Name Description Example
INSERT INTO <tablename> [<columns>] {values | <select>} INSERT INTO table (column1,column2) VALUES (1, 'one')
INSERT INTO table_name VALUES (value1, value2,....)
INSERT INTO table_name (column_name1, column_name2,...) VALUES (value1, value2,....)
INSERT INTO supplier (supplier_id, supplier_name) SELECT account_no, name FROM customers WHERE city = 'Newark'