Transactions is working Mysql Module

[Aboud Akhdir]

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