Insert Records Into a Table using SQL

To insert records into a table using SQL:

INSERT INTO table_name (column_1, column_2, column_3,...)

VALUES

('value_1', 'value_2', 'value_3', ...)

The Example

Assume that you created an empty table called the ‘product‘ table which contains 3 columns: product_id, product_name, and price:

CREATE TABLE product (
	product_id int primary key,
	product_name nvarchar(50),
	price int
)

The ultimate goal is to insert the following 4 records into the table:

Insert Records Into the Table using SQL

The query below can be used to insert the 4 records into the ‘product‘ table:

INSERT INTO product (product_id, product_name, price)

VALUES

(1,'Computer',800),
(2,'TV',1200),
(3,'Printer',150),
(4,'Desk',400)

After running the above query, the 4 records will be inserted into the ‘product‘ table.

To verify that the records were added to the table, run the following SELECT query:

SELECT * FROM product

You’ll now see the newly inserted records:

Insert Additional Records to the Table

You can insert additional records to the table at anytime using the same technique as reviewed above.

For example, here is a query to insert two additional records into the ‘product‘ table:

INSERT INTO product (product_id, product_name, price)

VALUES

(5,'Chair',120),
(6,'Tablet',300)

After running the query, the two additional records will be inserted into the table.

Rerun the SELECT query:

SELECT * FROM product

You’ll see that the two additional records were indeed inserted at the bottom of the table:

You may also want to check the following page for additional SQL tutorials.