Insert (SQL): Meaning (information, definition, explanation, facts)

A SQL INSERT statement adds a record to a table in a relational database.

Insert statements have the following form:

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

The number of columns and values must be the same. If a column is not specified, the default value for the column is used. The values specified (or implied) by the INSERT statement must satisfy all the applicable constraints (such as primary keys, CHECK constraints, and NOT NULL constraints). If a syntax error occurs or if any constraints are violated, the new row is not added to the table.

Example:

INSERT INTO phone_book (name, number) VALUES ('John Doe', '555-1212')