Find the answer to your Linux question:
Results 1 to 2 of 2
Hi, I am using mysql server 5.0.45. mysql> create table t1(f1 int); Query OK, 0 rows affected (0.00 sec) mysql> set autocommit=off; Query OK, 0 rows affected (0.00 sec) mysql> ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Mar 2007
    Posts
    3

    MySQL server 5.0.45: auto commit = off not working. its always in on state


    Hi,

    I am using mysql server 5.0.45.

    mysql> create table t1(f1 int);
    Query OK, 0 rows affected (0.00 sec)

    mysql> set autocommit=off;
    Query OK, 0 rows affected (0.00 sec)

    mysql> insert into t1 values(1);
    Query OK, 1 row affected (0.01 sec)

    mysql> select * from t1;
    +------+
    | f1 |
    +------+
    | 1 |
    +------+
    1 row in set (0.00 sec)

    mysql> rollback;
    Query OK, 0 rows affected, 1 warning (0.00 sec)

    mysql> select * from t1;
    +------+
    | f1 |
    +------+
    | 1 |
    +------+
    1 row in set (0.00 sec)

    can anybody help me with the fix of this.
    If I can set the fix with some configuration values in my.cnf, it would be of great help.
    Since i will be using sql files to work on many other databases as well using unixodbc driver.

    Cheers

  2. #2
    Just Joined! andriagutama's Avatar
    Join Date
    Jul 2008
    Location
    Batam, Indonesia
    Posts
    34
    rollback didn't work at all???
    try to restart mysql server first

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •