I think you can try this code.

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

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

$dbh->execute();

$dbh->disconnect();
[download]

As mentioned by zwon (Deacon), quote your values.

Also, the command to clear screan in windows is system("cls")

Thanks