|
04-13-2006, 04:54 AM
|
#1 |
|
Junior Member
Join Date: May 2005
Posts: 9
|
Record Locks - is it possible?
I can't seem to find an answer in the literature, but is it possible in 4.1 to place a lock on a particular record? Say, to prevent changes to the record while being viewed.
There's plenty on table locks but no record locks. Are these not supported? |
|
|
|
04-13-2006, 10:50 AM
|
#2 |
|
Senior Member
Join Date: Jul 2004
Posts: 167
|
Re: Record Locks - is it possible?
There was talk of record-level locking. If I remember correctly, this was an issue that mysql.com fought mysql.org over and brought about their splitting up companies. Later on I think mysql.com did win a squabble and got the rights for the mysql.org domain. I believe there is a version out there that features row locking, but it is a version that requires payment. That was the status last time I checked. I'm going to see if I can find out more.
__________________
** Most misspellings intentional to combat spaham filterz** |
|
|
|
|
04-13-2006, 10:53 AM
|
#3 |
|
Senior Member
Join Date: Jul 2004
Posts: 167
|
Re: Record Locks - is it possible?
Here you go, you need mysql version 5 AND the database has to be of type INNODB.
http://dev.mysql.com/doc/refman/5.0/...l-locking.html
__________________
** Most misspellings intentional to combat spaham filterz** |
|
|
|
 |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do you pull every 40th record out of a table? | Azkaban | SQL syntax | 1 | 01-18-2005 04:36 AM |
| Configure an MX record | Azkaban | Sendmail | 0 | 07-08-2004 10:06 PM |
