SELECT LOCK IN SHARE MODE and FOR UPDATE
Posted by peter |
Baron wrote nice article comparing locking hints in MySQL and SQL Server.
In MySQL/Innodb LOCK IN SHARE MODE and SELECT FOR UPDATE are more than hints. Behavior will be different from normal SELECT statements. Here is simple example:
del.icio.us
digg