Skip to main content

query

Overview​

Execute a SQLite database SQL query, supports three output formats: csv, column, list

Command Parameters​

-d|--database=string    Required parameter,Database file path. Example: /sf/log/log_new.db
-s|--sql=string         Required parameter,SQL statement. Example: SELECT * FROM alert LIMIT 10
-f|--format=string      Output format. Optional values: csv, column, list. Default: column

Example​

acli system file sqlite3 query --database /tmp/test.db --sql 'SELECT 1'

Sample Output​

1