# list all dbs SHOW DATABASES; USE db; # list all users SHOW USERS; # list measurements SHOW MEASUREMENTS; # read value from a measurement_var SELECT * from "MEASUREMENT_VAR"; # list series SHOW SERIES; # list tag keys SHOW TAG KEYS;

sqli influxql

influxDB (written in Go) is an open source time-series database that is used for storage and retrieval of time series data.

Connect

InfluxDB supports both password and JWT based authentication. JWT is an authentication method that is based on a "shared secret", which is known to both parties. If an external party knows the "secret", it can create valid tokens and authenticate with them.

influxql commands

# list all dbs
SHOW DATABASES;
USE db;

# list all users
SHOW USERS;

# list measurements
SHOW MEASUREMENTS;

# read value from a measurement_var
SELECT * from "MEASUREMENT_VAR";

# list series
SHOW SERIES;

# list tag keys
SHOW TAG KEYS;

References

Previoussqli basic Nextsqli mongo

Last updated 3 years ago

Was this helpful?