Ben,
- Original Message -
From: "Ben Goswami" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 29, 2002 4:40 PM
Subject: Re: how to set autocommit
> Heikki ,
> Thanks for your reply. So wh
ert 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 1
day, 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
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 wher
Andre,
I did not find such an option in my.cnf. But I agree that there should
be one. I will ask Monty to add that option to my.cnf.
Regards,
Heikki
.
Hi,
I would like to set autocommit = 0 as the default value when running the mysql
frontend. (Maybe with a
Hi,
I would like to set autocommit = 0 as the default value when running the mysql
frontend. (Maybe with an entry in my.cnf)
Is that possible ???
Andre
--
E-Mail: [EMAIL PROTECTED]
Date: 08-May-01
Time: 15:42:09
() Join the ASCII ribbon campaign against html
Hi, everybody, I have a couple of quesitons
1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set
autocommit=0' and this only applies to a session. So, when I want to back up data
using 'shell>mysql datablse < data.sql', do I need to add 'set autocommit=0' at th
Hi, everybody, I have a couple of quesitons
1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set
autocommit=0' and this only applies to a session. So, when I want to back up data
using 'shell>mysql datablse < data.sql', do I need to add 'set autocommit=0' at th
