+
1 row in set (0.00 sec)

当要更新数据的时候根据带上版本号更新：

mysql> update lock_test set name = "xiaoming", version = version + 1 where id = 1 and version = 0;
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0

第二个终端再根据`0` 的版本号更新数据就不会操作成功：

mysql> update lock_test set name = "xxxxxx", version = version + 1 where id = 1 and version = 0;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0 -- 影响行数为0