Sha256: e9d2e2355f34b8156aa66091e39100efbcbd4c5e8e2f09bf9bb0b360d4f3a6d7
Contents?: true
Size: 929 Bytes
Versions: 16
Compression:
Stored size: 929 Bytes
Contents
SYSTEM OBJECT TYPE
NAME: query
SHORTCUT: sql
DESCRIPTION
A SQL Query.
A SELECT, INSERT, UPDATE or other SQL statement.
The query requires a valid database connection.
CHILDREN
database - string
The name of the database.
sql - string
The SQL query to execute.
result - container
The result of the query will be a container for each row,
with an object for each column.
The result container is optional. If it is not present,
the results will be displayed in the console.
params - container
Optional list of parameters for the query.
MESSAGES
run - Run the query and get back the data.
EXAMPLE
sqlite [can] :
on_load [script] : run sqlite.sql
db [sqlite] :
database : test.db
sql [query] :
database [alias] : sqlite.db
sql : SELECT id, key, value FROM key_values
SEE ALSO
mysql, sqlite
Version data entries
16 entries across 16 versions & 2 rubygems