Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Mar 2009
    Posts
    74
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Concurrency in mysql database

    i want to maintain concurrency in mysql. like when user is updating a particular table then no can access this row. how could i can do this. or give me some tips to maintain concurrency in mysql or any other database indetail

    How would i get time in am or pm format by using curtime() function???????
    Last edited by deshi2003; 03-11-2009 at 06:23 PM.

  • #2
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    I'm not totally sure you can do this just in MySQL. You might have to implement an external locking solution to handle this in your application.
    OracleGuy

  • #3
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    If you use the engine InnoDB and transactions, you can do shared and exclusive locks on data.

    http://dev.mysql.com/doc/refman/5.0/...ock-modes.html

    Look up date_format() in the manual for answers to your second question.


  •  

    Posting Permissions

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