Skip to content

/sqlite

Syntax

/sqlite query <"Path to Database File"> <QueryName> QUERY
/sqlite open <ConnectionName> <"Path to Database File"> [FLAGS] | close <ConnName>
/sqlite [help | advquery | clear]

Description

The full power of SQLite at your disposal.

Options

clear <ResultName>
Clear your results from memory.
query <"Path to Database File"> <QueryName> QUERY
Simple usage.
open <ConnectionName> <"Path to Database File"> [FLAGS]
Open the database ConnectionName in read write mode with write ahead logging enabled.
advquery <ConnName> <ResultName> <QUERY>
This performs the query on the connection named ConnName and stores the result in ResultName. See Advanced Usage.
close <ConnName>
When you are done, you will want to close the connection to the database
help
Show the help and TLO information for the plugin.

This command is added by MQ2SQLite.