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 into employee(name, age) values('deepak', 40)
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.