How to deal with concurrent "update" in the same column? RRS feed

  • 問題

  • Uh...I encountered a more difficult problem:

    Premise:1.I can not use "lock" in my program because of my business needs.

    Scene: step1.two or more users submit update requests in the same time  Sql likes "update table set column1=username where xxx=xxx and column1 is null"

    Conclusion:All of those users receive message "success".The record's column1 was changed by one of those users'name with random. 

    Looking forward to your answer!

    Best Wishes to you!

    2013年4月19日 上午 08:12