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 r
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 se
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 se
On Saturday 04 January 2003 11:45, Clyde wrote:
> 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 (or the connection is terminated). But ho
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
(or the connection is terminated). But how do you release these record locks if you do
not w