# Mysql transactions via ruby

**URL:** <https://www.ruby-forum.com/t/mysql-transactions-via-ruby/106111>\
**Category:** Ruby\
**Created:** [June 6, 2007, 3:32pm UTC](https://www.ruby-forum.com/t/mysql-transactions-via-ruby/106111 "2007-06-06T15:32:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![paolo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/6f9a4e/32.png) [@paolo](https://www.ruby-forum.com/u/paolo)\
**Post date:** [June 6, 2007, 3:32pm UTC](https://www.ruby-forum.com/t/mysql-transactions-via-ruby/106111/1 "2007-06-06T15:32:20Z")

</div>

Hi,  
I’m trying to use transactions via “ruby mysql module” but there is no  
effect, just like the autocommit mode on.

for example:

```
mSql.query("set autocommit=0")
mSql.query("start transaction")
mSql.query("insert into TEST values ('ABCD')")
mSql.query("rollback")

the record remains in the table.

```

I’m using Mysql 5.0, Ruby 1.8, table engine InnoDB. The same sql  
operations  
works fine on mysql console.

any suggestion?  
thanks