Insert on time difference greater than

[Manny B]

Hi,

I have a python script that logs codes to a database via serial input. Is it possible to have a storage procedure that checks the last instance `receiver` and blocks the insert if the time difference is greater than 10 seconds.

At the moment I'm using this query to delete them at the end of the day.

DELETE b
FROM code_reader a
JOIN code_reader b ON a.tag_number= b.tag_number AND a.receiver=b.receiver
WHERE TIME_TO_SEC( TIMEDIFF(b.time,a.time)) BETWEEN 1 AND 10

Thank you

Manny