Difference between revisions of "Influx"
(Initial creation) |
(No difference)
|
Latest revision as of 21:05, 15 August 2023
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
