Create an Account
username: password:
 
  MemeStreams Logo

MySQL :: MySQL 5.0 Reference Manual :: 13.2.10.5 SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads

search

Lost
Picture of Lost
My Blog
My Profile
My Audience
My Sources
Send Me a Message

sponsored links

Lost's topics
Arts
Business
Games
Health and Wellness
Home and Garden
Miscellaneous
Current Events
Recreation
Local Information
Science
Society
Sports
Technology

support us

Get MemeStreams Stuff!


 
MySQL :: MySQL 5.0 Reference Manual :: 13.2.10.5 SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads
Topic: Technology 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.

MySQL :: MySQL 5.0 Reference Manual :: 13.2.10.5 SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads



 
 
Powered By Industrial Memetics
RSS2.0