locking a row or field

[peanuts]

Hi all,

Is it possible for me to lock a row within a table so only one user can update a specific row??

If it is is it possible to do so with a default time frame of which the row is blocked..

Thanks,

Peanuts

[HarryF]

Believe that MySQL doesn't come with row level locking but it's available in an update from NuSphere: http://www.nusphere.com/releases/013001.htm

Of course don't know how reliable that it, given recent conflicts between MySQL AB and NuSphere - http://www.mysql.com/news/article-75.html

[Abstraction]

Originally posted by HarryF
Believe that MySQL doesn't come with row level locking but it's available in an update from NuSphere: http://www.nusphere.com/releases/013001.htm

Reason 1 of many why not to use MySQL.

[MattR]

Originally posted by Abstraction


Reason 1 of many why not to use MySQL.

1 of many. LOL

[peanuts]

Hmm

MySQL is the only one my providers has ....

but anyway... happy withit untill this and I can do this with a flag or so... just wondering if it was standard

Greets

Peanuts