How to fix the blocking of records in the table?

Question

MySQL

I have 3 scripts running at the same time that update the same dataset.
At some point, I get an exception
Mysql: Deadlock found when trying to get lock; try restarting transaction
How to avoid similar? who faced?

Answer 1

https://dev.mysql.com/doc/refman/5.7/en/innodb-dea...