Isolation level per transaction?

Isolation level per transaction?

am 04.03.2011 07:32:42 von Angela liu

--0-215207767-1299220362=:28573
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

HI, Folks:

Can Isolation levels be set per transaction?=A0 I know isolation levels can=
be set per session or globally, but not sure at transaction level.

if so , can anybody give me an example?

Thanks a lot


=0A
--0-215207767-1299220362=:28573--

Re: Isolation level per transaction?

am 04.03.2011 15:35:12 von Perrin Harkins

On Fri, Mar 4, 2011 at 1:32 AM, Angela liu wrote:
> Can Isolation levels be set per transaction?=A0 I know isolation levels c=
an be set per session or globally, but not sure at transaction level.

Given that you can only have one transaction at a time in a session,
there is no real difference between session-level and
transaction-level.

- Perrin

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg