This command performs operations on the database
associated with the
created using a previous database connect
Execute the SQL statement
SQL-clause, returning the result as
a list. If the statement returns a single-column result set,
the returned string is a simple list, or an empty string if
nothing is found. If the command returns a multiple column
result set, a list is returned in which each element is a list
representing a single row of the result. If the statement does
not return a result set, the command returns OK.
SQL arguments may be given after
SQL-clause, where the argument
positions are marked with ? in the clause. This is usually
used with precompiled statements; see the description in the
db "select firstname, surname from employees, where id = $id"
Disconnect the database object from the datasource, removing the command from the interpreter.
Set a connection-specific option to a value. The supported options and value are listed here:
Turns autocommit on or off.
Set concurrency mode to one of
Set the maximum number of rows.
Set timeout in seconds.
Set the maximum length of data returned.
Set the row set size.
Set the cursor type to
type, which must be one of ...