Skip to content

Basics

InfluxDB Cheatsheet

Connect to InfluxDB using the commandline:

1
    $ influx

Create a database foo:

1
    CREATE DATABASE foo

List the databases:

1
    SHOW DATABASES

Select the new created database:

1
    USE foo

List measurements

1
    SHOW MEASUREMENTS

Show measurements for name: mars

1
    SELECT * FROM mars

Drop mars measurements

1
    DROP MEASUREMENT mars

Show field keys

1
    SHOW FIELD KEYS FROM "mars-A6"

Get power records from measurement with tag and time range

1
    SELECT "power" FROM "drilling" WHERE ("module_id"='rover') AND time >= now() - 9h

Show series

1
    SHOW SERIES

Drop all series for tag

1
    DROP SERIES FROM "drilling" WHERE ("module_id" = 'oppy')