INSERT Command

<< Click to Display Table of Contents >>

Navigation:  SQL Reference > SQL Commands >

INSERT Command

Previous pageReturn to chapter overviewNext page


An INSERT statement is used to add one or more new records to a table. This is how you populate a table. Each record is subdivided into fields and each field contains a single piece of data.


INSERT INTO [ MEMORY ] ["database_file_name".] table_name [ PASSWORD database_password ] [ ( column_name [, ...] ) ] { VALUES ( expression [, ...] ) | query }


INSERT allows one to insert new rows into a table. One can insert a single row at a time or several rows as a result of a query.

The columns in the target list may be listed in any order. Each column not present in the target list will be inserted using a default value, either its declared default value or null.

If the expression for each column is not of the correct data type, automatic type conversion will be attempted.



If MEMORY keyword is specified before the table_name then an in-memory table is referenced, not a disk one.



The database file name which must be specified only if INSERT operates with the tables from external database.



The name of an existing table.


PASSWORD database_password

The password to open encrypted external database specified by database_file_name.


column _name

The name of a column in table.



An expression or value to assign to column.



A query (SELECT statement) that supplies the rows to be inserted. Refer to the SELECT command for a description of the syntax.



INSERT INTO developers (code, name) VALUES (5, 'Bob');

INSERT INTO new_developers (SELECT * FROM developers WHERE code > 5);

INSERT INTO developers (code, name) VALUES (5, 'Bob'), (6,'John');


Note: See MimeToBin function for details on how to insert binary data.

Absolute SQL Reference - 05 January 2023, Niels Knabe