SQL server is the most popular database of microsoft company which was develop in 1989. SQL stands for Structure Query Language. It is RDBMs so in this case record is store in tabular format. It is platform dependent because it runs only on windows operating system.
SQL Insert INTO Value Statement
The SQL INSERT INTO Value Statement is use to add new rows of data to a table in the database is knows as INSERT INTO Value Query
Syntax
INSERT INTO table_name (column1, column2, column3, .... ) VALUES (values1, values1, values1, .... )
Example of SQL Insert INTO Value Statement
Part 1
INSERT INTO school2 (id, name, birth_date, phone, gender) values (1,"raj", "1990-10-10", 784561236, "m");
![](https://mlix28v01wde.i.optimole.com/w:382/h:77/q:mauto/f:best/https://basicengineer.com/wp-content/uploads/2022/12/image-34.png)
Output of SQL Insert INTO Value Statement
![](https://mlix28v01wde.i.optimole.com/w:412/h:104/q:mauto/f:best/https://basicengineer.com/wp-content/uploads/2022/12/image-35.png)
Example of SQL Insert INTO Value Statement
Part 2
INSERT INTO school2 (id, name, birth_date, phone, gender) values (2, "rohit", "1990-11-10", 784561236, "m");
![](https://mlix28v01wde.i.optimole.com/w:518/h:118/q:mauto/f:best/https://basicengineer.com/wp-content/uploads/2022/12/image-36.png)
Output of SQL Insert INTO Value Statement
![](https://mlix28v01wde.i.optimole.com/w:495/h:120/q:eco/f:best/https://basicengineer.com/wp-content/uploads/2022/12/image-37.png)
SQL INSERT INTO SELECT Statement
This statement copy data from one table and inserts it into another table is knows as SQL INSERT INTO SELECT Query.
Syntax
The Copy all columns from one table to another table.
INSERT INTO table2 SELECT * FROM table1 WHERE condition;
The Copy only some columns from one table into another table.
INSERT INTO table2 (column1, column2, column3, column3 ...) SELECT column1, column2, column3, column3 ... FROM table1 WHERE condition;
SQL INSERT INTO Multiple Statement
Syntax
Insert Into table_name (column1, column1, column1, ,,,, ) VALUES (value1, value2, value3, ....), (value1, value2, value3, ....), (value1, value2, value3, ....);
Example of SQL Insert Multiple Value statement
INSERT INTO person2 (id, name, birth_date, phone, gender) values (6, "rajan", "1998-09-11", 784561236, "m"), (7, "anu", "1993-11-11", 784561236, "m"), (8, "mohit", "1995-07-11", 784561236, "m"), (9, "shayam", "1997-04-21", 784561236, "m"), (10, "manmohan", "1999-11-12", 784561236, "m");
![](https://mlix28v01wde.i.optimole.com/w:465/h:185/q:eco/f:best/https://basicengineer.com/wp-content/uploads/2022/12/image-32.png)
Output of SQL Insert Multiple Value statement
![](https://mlix28v01wde.i.optimole.com/w:462/h:168/q:eco/f:best/https://basicengineer.com/wp-content/uploads/2022/12/image-33.png)
If you have any queries regarding this article or if I have missed something on this topic, please feel free to add in the comment down below for the audience. See you guys in another article.
To know more about SQL please Wikipedia click here .
Stay Connected Stay Safe, Thank you
0 Comments