in reply to How to check for new records in mysql database every minute

  • You use an update trigger on the tables involved. Oh, wait, MySQL doesn't have triggers.
  • You use a stored procedure to do inserts in the tables involved, and modify all programs not to touch the tables directly, but go through the stored procedures. Oh, wait, MySQL doesn't have stored procedures.
  • You replicate the tables involved using a repserver, dropping any deletions and updates, and check the tables at the other end. Oh, wait, MySQL doesn't have a repserver.
  • You use a real database.
    • Comment on Re: How to check for new records in mysql database every minute

    • In Section Seekers of Perl Wisdom