MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Reduce amount of rows
Posted by: Ole Mortensen
Date: June 28, 2012 03:18AM

Hello
I have a table containing a temperature logged every 5 seconds.
I want to reduce the amount of rows by only keeping the first and last record of every day and there between only the records when the value has changed.

Any idea how to do this?

Thanks in advance.

Ole M.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Reduce amount of rows
Ole Mortensen
June 28, 2012 03:18AM
Re: Reduce amount of rows
laptop alias
June 28, 2012 03:59AM
Re: Reduce amount of rows
Ole Mortensen
June 28, 2012 04:34AM
Re: Reduce amount of rows
Rick James
June 29, 2012 06:26PM
Re: Reduce amount of rows
laptop alias
June 30, 2012 05:56AM
Re: Reduce amount of rows
Peter Brawley
June 30, 2012 11:31PM
Re: Reduce amount of rows
Ole Mortensen
July 04, 2012 03:07AM


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.