Do you have a question? Post it now! No Registration Necessary. Now with pictures!
June 15, 2006, 2:56 pm
rate this thread
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/en/transactional-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,
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum