SQL INSERT STATEMENT
SQL INSERT statement is a SQL query. It is used to insert a single or a multiple records in a table.
There are two ways to insert data in a table:
- By SQL insert into statement
- By specifying column names
- Without specifying column names
- By SQL insert into select statement
1) Inserting data directly into a table
You can insert a row in the table by using SQL INSERT INTO command.
There are two ways to insert values in a table.
In the first method there is no need to specify the column name where the data will be inserted, you need only their values.
The second method specifies both the column name and values which you want to insert.
Let’s take an example of table which has five records within it.
It will show the following table as the final result.
ROLL_NO | NAME | AGE | CITY |
---|---|---|---|
1 | ABHIRAM | 22 | ALLAHABAD |
2 | ALKA | 20 | GHAZIABAD |
3 | DISHA | 21 | VARANASI |
4 | ESHA | 21 | DELHI |
5 | MANMEET | 23 | JALANDHAR |
You can create a record in CUSTOMERS table by using this syntax also.
The following table will be as follow:
ROLL_NO | NAME | AGE | CITY |
---|---|---|---|
1 | ABHIRAM | 22 | ALLAHABAD |
2 | ALKA | 20 | GHAZIABAD |
3 | DISHA | 21 | VARANASI |
4 | ESHA | 21 | DELHI |
5 | MANMEET | 23 | JALANDHAR |
6 | PRATIK | 24 | KANPUR |
2) Inserting data through SELECT Statement
SQL INSERT INTO SELECT Syntax
Note: when you add a new row, you should make sure that data type of the value and the column should be matched.
If any integrity constraints are defined for the table, you must follow them.