SQL Insert Statement

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 into employee values('john',22,'Delhi', 09812045241)
insert example 1
insert into employee(name, age) values('deepak', 40)

insert example 2

SUMMARY

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

 

Share your thought