Insert into SQL Tutorial

Insert into Syntax:

INSERT INTO table_name VALUES (value1, value2, ...)

OR

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...)

Store table:

OBJECT_IDPRICENAME
1200A
2500B
3900C
4500D

Example 1:

INSERT INTO store VALUES (5, 600, 'E');

Example 2:

INSERT INTO store(object_id, price, name) VALUES (6, 400, 'F');

OBJECT_IDPRICENAME
1200A
2500B
3900C
4500D
5600E
6400F