Описание тега sql-insert

SQL INSERT statement adds one or more rows to a single table in a relational database.

The basic INSERT values syntax is:

INSERT INTO table [ (column1 [, column2, column3 ... ]) ]
VALUES (value1 [, value2, value3 ... ]);

The INSERT SELECT syntax is:

INSERT INTO table [ (column1 [, column2, column3 ... ]) ]
SELECT c1 [, c2, c3 ... ] FROM table

Reference

• SQL Insert on Wikipedia
• SQL Server - on Microsoft TechNet
• Oracle
• MySQL
• SQLite
• PostgreSQL

For questions regarding SQL INSERT statement use this tag instead of insert.