RE: Unknown auto ROLLBACK

2002-10-01 Thread Noor Dawod

What is that option? Never saw it before.
If this is the case indeed, how do you change its value?

Thanks again.

Noor


-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 4:52 PM
To: Noor Dawod
Cc: MySQL List
Subject: Re: Unknown auto ROLLBACK


Because you did not set autocommit on?

Noor Dawod wrote:

Hi all,

I found out today that MySQL is adding a 'ROLLBACK' command to each
session connecting to it, without explicitly ordering this.
This is new since we never had this behavior before. Why is this
happening, and how can I revert to the old beahvior (each command sent
is carried out and performed instantly, with no rollback option.)

Please CC me in your replies. Thanks in advance.

Noor



-
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








-
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




Re: Unknown auto ROLLBACK

2002-09-30 Thread gerald_clark

Because you did not set autocommit on?

Noor Dawod wrote:

Hi all,

I found out today that MySQL is adding a 'ROLLBACK' command to each
session connecting to it, without explicitly ordering this.
This is new since we never had this behavior before. Why is this
happening, and how can I revert to the old beahvior (each command sent
is carried out and performed instantly, with no rollback option.)

Please CC me in your replies. Thanks in advance.

Noor



-
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


  




-
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