java - MySQL中，使用聚合函数+for update会锁表吗？

Question

比如 select count(*) frmo table_A for update

Answer 1

This can help you
http://blog.csdn.net/liqfyiyi...

Answer 2

innodb storage engine supports row locking.
Consider other storage engines in detail.

Answer 3

mysql, rr isolation mode, innodb storage engine, will lock each row

Answer 4

My personal feeling is table lock, innodb row lock is conditional
1: There must be where
2: The fields involved in where must have indexes
3: Large range lock. For example, id>=100 will lock all IDs greater than or equal to 100