select max(CustomerNumber + 1) from CustomerList

##</code><code>##

my $customer_number = $dbh->{'mysql_insertid'};