my $insert_query = "INSERT INTO test(id, stats) VALUES (?, ?);";	
$sth = $dbh->prepare($insert_query);

while(($key, $value) = each(%hash)){
	$sth->execute($key, $value);
	}