The following structure defines the SQL insert syntax in LiteDB. Keyworks are case-insensitive.
INSERT INTO {collection}[: {autoIdType}]
VALUES {doc0} [, {docN}]
collection
is the name of the collection where the documents will be insertedautoIdType
is one of the supported auto id types supported (GUID
,INT
,LONG
,OBJECTID
). If this construct is not present, the default value isOBJECTID
.- Every document after keyword
VALUES
must be a valid JSON object. Documents must be comma-separated.