MySQL Forums
Forum List  »  Views

Re: Help with query strategy for view on table
Posted by: Brian Dieckman
Date: January 16, 2019 09:54AM

I agree. Unfortunately the data is written into the tables from a PLC that doesn't have the ability to query and update, only insert rows.

You've got me thinking about using a trigger now. I can't control what goes in that table, but I can make a new table that holds the data in the way you describe and contains the logic necessary to match those values up, instead of a view.

Options: ReplyQuote

Written By
Re: Help with query strategy for view on table
January 16, 2019 09:54AM

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.