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. |