Re: How to Unlock a row?

2003-01-04 Thread Paul DuBois
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

Re: How to Unlock a row?

2003-01-04 Thread Clyde
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

Re: How to Unlock a row?

2003-01-04 Thread Heikki Tuuri
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

re: How to Unlock a row?

2003-01-04 Thread Victoria Reznichenko
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

How to Unlock a row?

2003-01-04 Thread Clyde
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