On Thu, Jul 18, 2002 at 04:25:25PM -0700, Chuck Simmons wrote: > sql query > > In addition to being able to specify an update lock or a shared mode > lock, one should be able to specify no lock. This is the moral > equivalent of the Sybase "noholdlock" option. This is useful if you > normally want to run in a high isolation environment but are, say, > running a transaction where you don't need repeatable reads for some > select in that transaction.
Using this: http://www.mysql.com/doc/S/E/SET_TRANSACTION.html Can't you just set the isolation level for the transaction before you run it? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, processed 1,074,129,418 queries (247/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php