mysql中行锁是什么

# Transaction-A

mysql> set autocommit = 0;

mysql> update innodb_lock set v='1001' where id=1;

mysql> commit;

# Transaction-B

mysql> update innodb_lock set v='2001' where id=2;

Query OK, 1 row affected (0.37 sec)

mysql> update innodb_lock set v='1002' where id=1;

Query OK, 1 row affected (37.51 sec)