Hi,
I have a quick question, which I did not find answerd by the manual:
Given this sample query:
SELECT COUNT(ID) FROM mytable WHERE property=value FOR UPDATE
Which rows in 'mytable' are locked after this query?
Every row with property=value, because these rows were used to calculate COUNT(ID).
No rows, because no row is actually returned / selected.
Thanks and greetings, Kai Ruhnau
-- This signature is left as an exercise for the reader.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]