MySQL Forums
Forum List  »  Triggers

Triggers
Posted by: Pete Elliott
Date: July 24, 2019 03:09PM

I am trying to develop a trigger within a table (table 1) which is being updated every 5 mins from an OPC connection.

I wish to insert data from table 1 into another table (table 2) however I wish to average the values over a 24 hour period therefore allowing me to reduce data within stored within table 2 to form am archive for the data for a period of > 12 months.

Timestamps within my table presently are shown as YYYY-MMM-DD 00:00:000

The columns within my table are

ID, Value, Timestamp, Description

Any help would be much appreciated

Options: ReplyQuote


Subject
Views
Written By
Posted
Triggers
355
July 24, 2019 03:09PM
136
July 24, 2019 04:30PM


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.