Insert (SQL)

INSERTInsertinginserts
An SQL INSERT statement adds one or more records to any single table in a relational database.wikipedia
40 Related Articles

PostgreSQL

PostgresPgSQLPgAdmin
This feature is supported by DB2, SQL Server (since version 10.0 - i.e. 2008), PostgreSQL (since version 8.2), MySQL, sqlite (since version 3.7.11) and H2.
For example, an INSERT statement might activate a trigger that checks if the values of the statement are valid.

Database trigger

triggerstriggerprocedural triggers
Note that the two separate statements may have different semantics (especially with respect to statement triggers) and may not provide the same performance as a single multi-row insert.
Be cautious of using additional INSERT/UPDATE/DELETE commands within your trigger, because trigger recursion is possible, causing unwanted behavior.

SQL

Structured Query LanguageSQL databaseSQL Databases
An SQL INSERT statement adds one or more records to any single table in a relational database.

Table (database)

tabletablesdatabase table
An SQL INSERT statement adds one or more records to any single table in a relational database.

Relational database

relational database management systemRDBMSrelational databases
An SQL INSERT statement adds one or more records to any single table in a relational database.

Primary key

Alternate keydefining database keykey
The values specified (or implied) by the statement must satisfy all the applicable constraints (such as primary keys, constraints, and constraints).

Check constraint

constraints constraintconstraints
The values specified (or implied) by the statement must satisfy all the applicable constraints (such as primary keys, constraints, and constraints).

Null (SQL)

NULL NULLs
The values specified (or implied) by the statement must satisfy all the applicable constraints (such as primary keys, constraints, and constraints).

SQL-92

SQL92SQL 92ANSI-92
A SQL feature (since SQL-92) is the use of row value constructors to insert multiple rows at a time in a single SQL statement:

IBM Db2 Family

DB2IBM DB2pureQuery
This feature is supported by DB2, SQL Server (since version 10.0 - i.e. 2008), PostgreSQL (since version 8.2), MySQL, sqlite (since version 3.7.11) and H2.

Microsoft SQL Server

SQL ServerMS SQLMS SQL Server
This feature is supported by DB2, SQL Server (since version 10.0 - i.e. 2008), PostgreSQL (since version 8.2), MySQL, sqlite (since version 3.7.11) and H2.

MySQL

M'''ySQLMySQL 4.1MySQL 4.x
This feature is supported by DB2, SQL Server (since version 10.0 - i.e. 2008), PostgreSQL (since version 8.2), MySQL, sqlite (since version 3.7.11) and H2.

SQLite

SQLite3SQLite 3SQLite4
This feature is supported by DB2, SQL Server (since version 10.0 - i.e. 2008), PostgreSQL (since version 8.2), MySQL, sqlite (since version 3.7.11) and H2.

H2 (DBMS)

H2H2 DatabaseH2 Database Engine
This feature is supported by DB2, SQL Server (since version 10.0 - i.e. 2008), PostgreSQL (since version 8.2), MySQL, sqlite (since version 3.7.11) and H2.

SQL:2003

SQLSQL standard2003 version of SQL
Note that this is not a valid SQL statement according to the SQL standard (SQL:2003) due to the incomplete subselect clause.

DUAL table

To do the same in Oracle use the DUAL table, which always consists of a single row only:

Firebird (database server)

FirebirdFirebirdSQLFirebird 2.1
In Firebird inserting multiple rows can be achieved like this:

Database schema

schemarelational schemaschemas
(Or when the tables' schemas are not the same.)

Surrogate key

Surrogatesurrogate-key
Database designers that use a surrogate key as the primary key for every table will run into the occasional scenario where they need to automatically retrieve the database generated primary key from an SQL INSERT statement for use in another SQL statements.