Hi, got a problem with the key locks, using InnoDB:
The mysql.com Manual reads:
SELECT ... FROM ... LOCK IN SHARE MODE: sets shared next-key locks on all
index records the read encounters.
SELECT ... FROM ... FOR UPDATE: sets exclusive next-key locks on all
index records the read encounters.
The Innodb-Manual reads:
SELECT ... FROM ... LOCK IN SHARE MODE
sets shared locks on all index records the read encounters.
SELECT ... FROM ... FOR UPDATE
sets exclusive locks on all index records the read encounters.
What locks are used for these statements?? shared locks or shared
next-key-locks
thanks for your help.
--
+++ Mailpower für Multimedia-Begeisterte: http://www.gmx.net/topmail +++
250 MB Mailbox, 1 GB Online-Festplatte, 100 FreeSMS. Jetzt kostenlos testen!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
