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:

product_idproduct_nameprice
1Computer800
2TV1200
3Printer150
4Desk400

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:

product_idproduct_nameprice
1Computer800
2TV1200
3Printer150
4Desk400

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:

product_idproduct_nameprice
1Computer800
2TV1200
3Printer150
4Desk400
5Chair120
6Tablet300

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

Leave a Comment