my $sth = $dbh->prepare("
    UPDATE tablename SET columname = ?
");
$sth->execute($data);