On Mon, Nov 17, 2003 at 10:10:52AM -0500, Andre Charbonneau wrote: > Hi, > > Let say that I have the following transaction: > > 1. Read value v1 from table t1. > 2. Do some computation using v1. > 3. Update value v2 from table t2. > > If in the above I don't want any other concurrent transaction to read v2 > until I'm done updating it, how should I put an exclusive lock on it? > > Using InnoDB, would the following be the way to do it (in transaction > mode, seriliazable isolation level)?
Have you tried it yourself? That would probably answer your question faster. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 64 days, processed 2,503,781,143 queries (445/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]