At 7:07 +0800 1/5/03, Clyde wrote:
Clyde,
----- Original Message -----
From: ""Clyde"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, January 04, 2003 11:47 AM
Subject: How to Unlock a row?
Hi,
Using MySql with InnoDB files you can lock rows for update.
Eg select * from customer where cusomerID=1 for update
I assume these locks are release when the the records selected are
actually updated
no.
Does this still hold true if MySql is running in autocommit mode?
And therefore does the query "select * from customer where
cusomerID=1 for update" only make sense to use if autocommit is OFF?
IE if Autocommit is on, and you run this query, are the records
still locked, or has an implicit COMMIT been issued because we are
running in autocommit mode - thus releasing the record lock.
The latter. In auto-commit mode, each statement is its own transaction.
Thanks
Clyde
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php