Re: Getting ID of last row inserted into database

Replies are listed 'Best First'.
Re^2: Getting ID of last row inserted into database by VSarkiss (Monsignor) on Jan 25, 2006 at 20:24 UTC
Indeed. I just want to point (for the OP) that support for `last_insert_id` varies greatly from DBMS to DBMS, and not all DBD's implement it in a reasonable way. Caveat selector. Do not rebuke them with harsh words ... but rather lead them gently - with URLs - so that they may learn wisdom.	[reply] [d/l]
Re^3: Getting ID of last row inserted into database by lima1 (Curate) on Jan 25, 2006 at 21:04 UTC
yes...had some problems with that, but with this parameter combination: `$self->db->dbh->last_insert_id(undef, undef, 'tablename', 'id_name');` [download] SQLite, MySQL 4.0 and PostgreSQL 8.1 all pass my tests. I think SERIAL UNIQUE NOT NULL was also necessary for Pg, but not sure.	[reply] [d/l]
Re^3: Getting ID of last row inserted into database by Yendor (Pilgrim) on Jan 26, 2006 at 15:20 UTC
Aye. Reading the DBI docs that Corion pointed me to were a great help. I ended up with the following as my call to `last_insert_id`: `my $LastID = $dbh->last_insert_id(undef, 'public', 'CUSTOMER_INFORMATION', 'ID');` -Yendor IWeThey	[reply] [d/l]