SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru
    Join Date
    Aug 2001
    Location
    Amsterdam
    Posts
    788
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    locking a row or field

    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
    the neigbours (free) WIFI makes it just a little more fun

  2. #2
    SitePoint Wizard gold trophysilver trophy
    Join Date
    Nov 2000
    Location
    Switzerland
    Posts
    2,479
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  3. #3
    code addict Abstraction's Avatar
    Join Date
    Apr 2001
    Location
    Des Moines, IA
    Posts
    346
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  4. #4
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Abstraction


    Reason 1 of many why not to use MySQL.
    1 of many. LOL

  5. #5
    SitePoint Guru
    Join Date
    Aug 2001
    Location
    Amsterdam
    Posts
    788
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ooopsss

    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
    the neigbours (free) WIFI makes it just a little more fun


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •