How to make sure that INSERT is executed on the result of SELECT atomically?

Question

MySQL

It is necessary to perform an INSERT if the result of the SELECT is empty. The SELECT checks for the intersection of the date period with the existing periods of the table, so it will not be possible to set a unique key.
How to make the operation pass atomically so that several processes at the same time cannot add intersecting periods?

Answer 1

If the table type allows, use a transaction

Answer 2

To check intersection in the trigger for addition, for example.

Answer 3

LOCK TABLES