MySQL Forums :: Stored Procedures :: Insert on time difference greater than


Advanced Search

Re: Insert on time difference greater than
Posted by: Peter Brawley ()
Date: May 17, 2016 12:44PM

They're stored procedures, not storage procedures.

To optimise the query that looks for the most recent insert per-receiver, you'll probably need a covering index (tag_number,receiver).

Options: ReplyQuote


Subject Views Written By Posted
Insert on time difference greater than 2043 Manny B 05/17/2016 11:21AM
Re: Insert on time difference greater than 402 Peter Brawley 05/17/2016 11:28AM
Re: Insert on time difference greater than 346 Manny B 05/17/2016 11:44AM
Re: Insert on time difference greater than 337 Peter Brawley 05/17/2016 12:44PM
Re: Insert on time difference greater than 368 Rick James 05/24/2016 10:37AM


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.