| Category | Name | Description | Example |
|---|---|---|---|
| INSERT INTO <tablename> [<columns>] {values |
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' |