How to set "strict sequence" in mysql? Can set the transaction queue as a thread?

Question

PHP

This is such an unfortunate situation. Applications fall into the database, but before adding a new application, it is checked whether there is the same one with the same number for the last hour. The script that makes requests to the database works asynchronously. And sometimes the database gives in both almost simultaneous requests the result that there is no application with this number and the script inserts data in both cases.
I would like all applications to reach, be checked for duplicates and not get lost...

Answer 1

MySQL has a locking mechanism .