my $dbh = DBI->connect('DBI:mysql:yourmysqldatabasename','root','password')||die "can't connect to dabase:$DBI::errstr";

my $dbh=$dbh->prepare("UPDATE TableName SET ColumnName=\"$value\" where ColumnName=$value2 ");

$dbh->execute();

$dbh->disconnect();