472,142 Members | 1,275 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,142 software developers and data experts.

is mysql 5 able to manage transactions between different users ?

hi !
in mysql doc it is stated that :
"MySQL supports local transactions (within a given client connection) "
ref : http://dev.mysql.com/doc/refman/5.1/...-commands.html
but what happens if for instance 2 different users tries to modify same
data in 2 different transactions in 2 different connections ?
does the last one which finish simply "win" (erasing the other's work)
or does mysql is able to lock rows in a correct way via transaction
managed locks like oracle/postgrsql/sqlserver/etc. between users' sessions ?
thx & regards,
Jun 15 '06 #1
0 1177

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Abhi | last post: by
reply views Thread by Mike Chirico | last post: by
2 posts views Thread by JP | last post: by
10 posts views Thread by smorrey | last post: by
33 posts views Thread by Joshua D. Drake | last post: by
12 posts views Thread by vpr | last post: by
6 posts views Thread by Atli | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.