MySQL Forums
Forum List  »  Connector/C++

Re: Run multiple update / select from one query
Posted by: nobody nobody
Date: November 27, 2017 12:21AM

I think I fixed it:

update Device, (select id, alertState, lastContact from Device where lastContact < 1511765116 and alertState = 0) as statement set Device.alertState = 1 where Device.id = statement.id;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Run multiple update / select from one query
14
November 27, 2017 12:21AM


Sorry, only registered users may post in this forum.

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.