DBMSSQL

Insert Operation in SQL

Insert Operation

After creating the tables, we have to insert data in it so that it can be called database. 

For this we use INSERT INTO command. 

INSERT INTO command adds or appends new rows (records) to a table created using create table command or any existing table. The syntax for INSERT INTO command is:

INSERT INTO < TABLE NAME >  VALUES( < value1 >, < value 2 >, ....  < value N > );

Here we will add some rows to our existing table STUDENTS for example purposes. To learn how to create table click here

INSERT INTO STUDENTS VALUES(10001, AAQIB, BA, 9596000000); 

This will add these details to our students table and you can add rows as many as you want to add in your students table.

Note that you have to enter details in the same order your have created table columns

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also
Close
Back to top button