MySQL Forums
Forum List  »  Triggers

Re: limit logging to once a second
Posted by: Darren White
Date: March 05, 2012 07:19AM

perhaps I could "SELECT" the last entry from the log table and check that against the "NEW.last_update" on the main table? That should work? I'll try that now... how would I select the most recent entry in a table (within a trigger)? I have auto increment ID So could also try find the row with largest row ID?

Options: ReplyQuote

Written By
March 05, 2012 07:04AM
Re: limit logging to once a second
March 05, 2012 07:19AM

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.