SQL Insert Statement

OBJECTIVE

In this chapter you will learn:

About insert statement
Syntax of insert statement
Example of insert statement

 

About insert statement

SQL insert statement is used to insert data into table. You can use this command to store values in the database.

Syntax of top statement

insert into table_name values (value1, value2, value3, value4,…..)

You can also use insert statement to add records in specific cell of the table. Syntax is given below-

Insert into table_name (column1, column2, column3,…) values (value1, value2, value3, value4,….)

Example of insert statement

 

 

insert example 1

 

 

 

 

insert example 2

 

SUMMARY

In this chapter you have learned about insert statement so you can add records in the table. In the next chapter you will learn about update statement.

 


Leave a Reply

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