In the last episode (Dec 22), Jason J. W. Williams said:
> I guess I'm curious why this query acquires a read lock. Is it
> because its in a transaction? Thank you very much in advance!
You mean as opposed to a write lock? Only inserts and updates need
write locks.
Or do you mean why is it locking at all? All selects need to lock the
data they're reading to prevent inserts or updates from changing the
records out from under the select while its running. MyISAM does it by
locking the entire table.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
