https://wiki.rodaw.com/w/index.php?action=history&feed=atom&title=InfluxInflux - Revision history2026-06-02T10:21:02ZRevision history for this page on the wikiMediaWiki 1.30.0https://wiki.rodaw.com/w/index.php?title=Influx&diff=1098&oldid=prevJeffa: Initial creation2023-08-16T04:05:36Z<p>Initial creation</p>
<p><b>New page</b></p><div>Jog my memory for some initial influx syntax<br />
<source lang="bash"><br />
$ influx -precision rfc3339<br />
> show databases<br />
> use homeamation_test<br />
> show measurements<br />
> show series<br />
> select * from sensorReads limit 2<br />
> drop measurements ....<br />
// 0B5CBE garage d1 mini id<br />
> select * from sensorReads where deviceId='0B5CBE' limit 100 use ' not "<br />
> select * from sensorReads where deviceId='0B5CBE' order by time desc limit 1<br />
</source></div>Jeffa