in reply to mysql pull back highest column

That way I can +1 in my perlish ways to help complete my current script

This suspiciously sounds as if you're trying to manually create a primary key for your table. That's bad because if your script runs twice at the same time, you can get the same number twice:

# Two scripts in parallel: my $highest_id1 = $dbh->do("select max(id) from my_table"); # first sc +ript my $highest_id2 = $dbh->do("select max(id) from my_table"); # second s +cript $highest_id1++; # first script $highest_id2++; # second script if ($highest_id1 == $highest_id2) { die };

What you want is a primary key on your table. In most SQL databases, you can do that with:

create table my_table ( id integer primary key not null, .... ); -- or create unique index idx_id on my_table (id); -- or, in MySQL I think: create table my_table ( id integer not null auto_increment, .... );

Also read the DBI documentation on retrieving the last insert id.