Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    india
    Posts
    12

    Unanswered: How can i lock row in database?

    How to lock row for operation so other operation can not read that row.

    I want to maintain concurrency. is there any way to lock row?
    Is mysql support row level locking?
    If yes how?

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: How can i lock row in database?

    Originally posted by bhawin13
    How to lock row for operation so other operation can not read that row.

    I want to maintain concurrency. is there any way to lock row?
    Is mysql support row level locking?
    If yes how?
    Yes, MySQL supports row level locking but you need to use InnoDB database engine.

    FYI: locking is not for select queries but it prevents DML queries!
    Last edited by ika; 04-17-04 at 09:30.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I suspect that this question is related to another question you posted. Which database engine are you using?

    -PatP

Posting Permissions

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