From the wonderful RedGuides Wiki

This command is added by MQ2SQLite

Syntax Key
Notation Description
Text without brackets or braces Required items
<Text inside angle brackets> Placeholder for which you must supply a value
[Text inside square brackets] Optional items
Vertical bar (|) Separator for mutually exclusive items; choose one
{Text | inside | braces} Set of required items; choose one
Ellipsis () Items that can be repeated
Syntax /sqlite [clear | query | open | advquery | close]
Description The full power of SQLite at your disposal.


Option Description
clear <ResultName> Since the results of the query are stored in memory, this can take up a lot of memory if you use unique query names and do not clear your results from memory. So, don't do that. Be sure to use the /sqlite clear <ResultName> function when you're done accessing the results.
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. If no flags are passed then the default flags of <"Path to Database File"> are used.
advquery <ConnName> <ResultName> <QUERY> This performs the query on the connection named <ConnName> and stores the result in <ResultName>.
close <ConnName> When you are done, you will want to close the connection to the database


/sqlite query <"Path to Database File"> <QueryName> QUERY

For the above documentation, here's an example command:

/sqlite query C:\Test.db myquery SELECT * FROM Table;

See the plugin page for more usage examples.

See also