Topic: MySQL Trend Queries ... anyone?
I have a database of weather information, which is updated from a sensor array every minute ... and uploaded etc.
What I would like to do is insert a column into a query that would return whether a value was trend upwards or downwards. In other words lets say the Barometer reading in the last row recorded is reading 1020.0 whereas in 10 rows previous it was reading 1019.5, the result would be a rising trend ... Has anyone got a grasp of conditional IF query application in MySQL.?