From: Aboud Akhdir
Date: March 13 2001 2:31pm
Subject: Transactions is working Mysql Module
List-Archive: http://lists.mysql.com/perl/1070
Message-Id: <200103131431.ABY18661@mail.maktoob.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1256
Content-Transfer-Encoding: 7bit

Dear MySQL Module Users:

By help from Mr. Gerry Walsh, we could make transactions work on Mysql Module
and here is a sample, how to perform it..

#!/usr/bin/perl

use DBI;

$dbh =
DBI->connect("DBI:mysql:database=test;host=anhost","root","anypassword");

$dbh->do('begin');
$rows = $dbh->do("insert into test1 (id, name) values ('20', 'rm')");

$dbh->do('commit');

$dbh->disconnect();


Or you can do this:

$dbh->do('rollback');

Regards to all of you,
Aboud Akhdir

_________________________________________________________
Send Your favorite Arabic Song from Maktoob Melodies,  http://melodies.maktoob.com