Easiest thing I can think of would be to add an oid column to your tables as an auto_increment field (and make it an index.) Then you've got your unique id per row, and after an insert you can get it from $sth->{mysql_insertid} or $dbh->{mysql_insertid}.