my $ref = $dbh->selectcol_arrayref(
    "SELECT LAST_INSERT_ID() FROM tbl
");