Influx

From Review or Discard at Will
Revision as of 21:05, 15 August 2023 by Jeffa (talk | contribs) (Initial creation)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Jog my memory for some initial influx syntax

$ influx -precision rfc3339
> show databases
> use homeamation_test
> show measurements
> show series
> select * from sensorReads limit 2
> drop measurements ....
// 0B5CBE garage d1 mini id
> select * from sensorReads where deviceId='0B5CBE' limit 100                   use ' not "
> select * from sensorReads where deviceId='0B5CBE' order by time desc limit 1