my $sql = "INSERT INTO TableName(Date,FileName) VALUES($Date,$file)"; my $stmt = $settle_dbh->prepare($sql); $stmt->execute();