Select Into

Table of Contents



SELECT ... INTO writes the results of a query to a schema. The schema is created if it does not exist. Each result row becomes a document whose fields are the selected field names.

round-pushpin Copies the English words into a new schema.
SELECT
    Id, Text
INTO
    WordList:EnglishWords
FROM
    WordList:Word
WHERE
    LanguageId = 1

round-pushpin Copies every document of a schema.
SELECT * INTO WordList:WordCopy FROM WordList:Word




SQL :: Distinct
Removes duplicate rows from the results of a SELECT.
SQL :: Expressions
Literals, operators, comments and variables in KBSQL.
SQL :: Insert
Insert creates new documents in a schema.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: Select
Select statements are used to read (or query) data from the database.
SQL :: Single
A built-in schema containing exactly one document, used to evaluate constant expressions.
SQL :: Update
Update changes fields of existing documents.