mysql好像不支持row-level的锁定吧！我查了一下mysql4.1 reference 只有表类型为InnoDB 使用row locks.
http://dev.mysql.com/doc/refman/4.1/en/internal-locking.html
还有如下一段话：
Instead of using row-level locks, you can employ application-level locks, such as GET_LOCK() and RELEASE_LOCK() in MySQL. These are advisory locks, so they work only in well-behaved applications.
http://dev.mysql.com/doc/refman/4.1/en/internal-locking.html
还有如下一段话：
Instead of using row-level locks, you can employ application-level locks, such as GET_LOCK() and RELEASE_LOCK() in MySQL. These are advisory locks, so they work only in well-behaved applications.
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货