This statement allows you to insert a single or multiple records into the database. We can specify the name of the column in which we want to insert the data. |
Syntax: Insert into table_name values (value1, value2..); |
The Insert statement has mainly three clauses. |
1). Insert: It specifies which table column has to be inserted in the table. |
2). Into : It tells in which the data will be stored. |
3). Values: In this we insert the values we have to insert. |
We can also specify the columns for which we want to insert data. |