The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

MySQL row based table locking like Oracle's OraRowScn

Hello,
how do you guys go for row based table loking in Mysql?

I never did this in Mysql, but I did it in oracle using "ora row scn", which makes it very simple because it can be done with an extra sql condition, for example

update table ... where obj_x = 0 and ora_rowscn = obj_orarowscn

So basicly the object would just need to be loaded with the "ora row scn" value at select time, and if any updates were done to the row in the table, the ora would change and the sql would "fail".

Any simple way like this to do it in mysql?

Thanks.
ICodeThereForeIAmBored
Friday, October 05, 2007
 
 
Note:
Wouldn't want to use all the "old values" to check if the row was changed.
ICodeThereForeIAmBored
Friday, October 05, 2007
 
 
Use InnoDB type of tables instead of the default MyISAM.
Berislav Lopac Send private email
Friday, October 12, 2007
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz