INSERT Command
|
Previous Top Next |
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.
|
The password to open encrypted external database specified by database_file_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.
|