Just to note, when doing a dynamic SQL statement building, it is usually a very bad idea to do simple string substitution based on the user input. You open yourself to SQL injection attacks among other things, like proper special character handling, etc. There is a much better option of using binding with prepare method of DBI package.

my $dbh = DBI->connect($data_source, $opts...);
my $update_stmt = $dbh->prepare("UPDATE tbl_name SET `CUSTOMER NAME` =
+ ?, AGE = ?, STATUS = ?, ...");

...

$update_stmt->execute(
        defined $customer_name ? $customer_name : undef,
        defined $age           ? $age           : undef,
        defined $status        ? $status        : undef,
        ...);
[download]

Regards,

- caelifer