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' |