Influx

From Review or Discard at Will
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