MemeStreams | MemeStreams Discussion

Create an Account

This page contains all of the posts and discussion on MemeStreams referencing the following web page: MySQL :: MySQL 5.0 Reference Manual :: 13.2.10.5 SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads. You can find discussions on MemeStreams as you surf the web, even if you aren't a MemeStreams member, using the Threads Bookmarklet.

MySQL :: MySQL 5.0 Reference Manual :: 13.2.10.5 SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads by Lost at 11:16 pm EDT, Apr 3, 2008
3.2.10.5. SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads In some circumstances, a consistent read is not convenient. For example, you might want to add a new row into your table child, and make sure that the child has a parent in table parent. The following example shows how to implement referential integrity in your application code.
Link - Reply