话不多说,就一个StackOverflow回答:
The point is that Optimistic Locking is not a database feature, not for MySQL nor for others: optimistic locking is a practice that is applied using the DB with standard instructions.
https://stackoverflow.com/questions/17431338/optimistic-locking-in-mysql
作者:Diego Mazzaro
Fantastic answer.