Heikki ,
Thanks for your reply. So what should I do in the mean time. Is there a
work around.
1. Can I put in the connect string?
like
DBI->connect("DBI:mysql:database=devdb;host=localhost",
{'RaiseError' => 1, 'AutoCommit => 0});
This does not work.
2. Should I use begin like ($sth is the the DB handle)
$sth->do("begin")
$sth->do("insert into...")
$sth->rollback()
or anything else.
I tried from setting up a mysql prompt, and still does not take it like
mysql>set autocommit=0
mysql>insert into...
mysql>rollback
when I do that it says Error 1196 Warning: Some non-transactional changed
tables couldn't be rolled back
Thanks
Ben
----- Original Message -----
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 28, 2002 11:37 PM
Subject: Re: how to set autocommit
> Ben,
>
> I have added the following item to the TODO list of September 2002. I
guess
> it will appear only in the MySQL-4.0 branch, as 4.0 will be the new stable
> branch within a few months.
>
> ...
> September, 2002:
> Add a global MySQL my.cnf option autocommit_default=0.
> ...
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> ---
> InnoDB - transactions, hot backup, and foreign key support for MySQL
> See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
>
> ----- Original Message -----
> From: ""Ben Goswami"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Monday, July 29, 2002 7:52 AM
> Subject: how to set autocommit
>
>
> > Hi,
> > Where should I change the autocommit setting to 0 (i.e no Autocommit).
> I'm
> > inserting row from perl script using DBI. I would like to bring up mySQL
> > server with autocommit false, so that I can explicitly commit from the
> front
> > end. But with lot of research in various docs I could not find where to
> > changer the settings. If I supply it in the connect string, it does not
> > take it.
> > Any help is appreciated
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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
>
---------------------------------------------------------------------
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
