my $sql='UPDATE table SET '.join',',map {"$_=".quote($hash{$_})} keys %hash; #### UPDATE table SET phone='456' #### map {"$_=".quote($hash{$_})} grep defined $hash{$_},keys %hash;
## UPDATE table SET phone='456' ##
## map {"$_=".quote($hash{$_})} grep defined $hash{$_},keys %hash;