mysql锁和oracle_select...forupdate在mysql和oracle间锁行为的比较_MySQL

bitsCN.com

select...for update在mysql和oracle间锁行为的比较

环境：

[sql]

mysql> show variables like '%storage_engine%';

+----------------+--------+

| Variable_name | Value |

+----------------+--------+

| storage_engine | InnoDB |

+----------------+--------+

1 row in set (0.00 sec)

mysql> select version();

+-----------+

| version() |

+-----------+

| 5.1.52 |

+-----------+

1 row in set (0.06 sec)

[sql]

SQL> select * from v$version where rownum=1;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

SQL> !uname -a

Linux Think 2.6.32-220.el6.x86_64 #1 SMP Wed Nov 9 08:03:13 EST 2011