optimistic concurrency - Does MySQL have an equivalent of SQL Server rowversion?

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams

I am migrating a SQL Server database schema over to MySQL. Some of the tables on SQL Server have a column of type rowversion. This is an integer value that is set when the row is first inserted and then again each time any column of the row is updated. The number is only ever incremented.

We make use of this to check for concurrency problems. So when an insert comes to the server we can check if the incoming value is different to the current stored value. If so, then the row has been updated since the read that has led to this insert. We can then reject the update because it is based on out of date values. Optimistic concurrency.

Is there an equivalent that will do the same for us in MySQL?

Not that I know of. But if you’re in control of all UPDATE statements, shouldn’t this be easy enough to implement yourself? A column


    myrowversion

that is initialized with 0 when a record is created, and on every UPDATE use


    SET myrowversion = myrowversion + 1

. And if you combine it with a WHERE clause on the UPDATE statement,


    UPDATE table SET …, myrowversion = myrowversion +1 WHERE record_id = … AND myrowversion = {value you read earlier}

– that should about achieve the same, right? – CBroe Oct 19, 2015 at 22:29

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question . Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers .

推荐文章

豪气的感冒药 · 王欣：血液病治疗的领军人 -齐鲁医学院人事人才办公室

2 周前

买醉的海豚 · 驾驭哥布林的黑兽团长不会梦到萌王_百度百科

2 周前

直爽的匕首 · 历届掌校人-天津大学

1 月前

俊秀的松球 · 坚持和完善党和国家监督体系为全面建成小康社会提供坚强保障——在中国共产党第十九届中央纪律检查委员会第四次全体会议上的工作报告_反腐倡廉_国家外汇管理局门户网站

1 月前

沉稳的炒饭 · java、c、c++、vc、vc++、vb的区别和联系_c++和vb的区别-CSDN博客

3 月前