How we can insert data into a table in SQL?

Insert Quary in SQL Database

The INSERT query is used to insert the data record (or a new row) in a table by using the INSERT INTO statement. The two ways are used for inserting rows in a table.

Syntax of Insert Quary in SQL

If you want to insert data (or insert a row) in a table by using an SQL database, here is the query syntax to insert data:

1. Only Values

INSERT INTO table_name ('column1', 'column2', 'column3'...)

VALUES ('value1', 'value2', 'value3',...);

2. Using SELECT in INSERT INTO Statement

INSERT INTO first_table

SELECT * FROM second_table;