MySQL Forums
Forum List  »  Newbie

Average every n records
Posted by: Afonso Marques
Date: April 10, 2018 10:00AM

Hi everyone,
I have a simple database made of 2 columns: id, temperature.
I am populating it every 5 seconds with a new reading which means that after 24h i will have 17280 new records.
Can anyone help me converting the last 17280 records into a set of (for instance) 1440 representing the average of temperatures recorded per minute, i.e. calculate the average temperature every 12 records?
Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Average every n records
April 10, 2018 10:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.