Hello,
I am using DBI Version 1.42 on OSX, accessing a MySQL database on
Linux (Mandrake)
Previously I have been using DBI with mysql on Linux, I always used
$sth=$dbh->prepare("INSERT INTO ......");
$sth->execute() or die();
$ID = $sth->{insertid};
To obtain the last insert id.
But this does not seem to work on OSX with DBI 1.42 there is no error
it just Returns undef.
The documentation has
$ID = $dbh->last_insert_id();
The parameters are ignored for MySQL, but this does not work either
I found on the net
$ID = $dbh->{'mysql_insertid'};
Why dont the other two work, and is there a more portable method to
obtain the last insert id.
Re: free database server for desktop application with ado.net driv ... > I've used MySQL on Windows since its 3.x days, ... If it works at all on linux,... people who have problems compiling it post about it because they want their own optimizations. ... (microsoft.public.dotnet.languages.csharp)
RE: FreeBSD 5.3 MySQL Performance ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers.... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ... (freebsd-questions)
Re: Not exactly a dbi question ... Not exactly a dbi question [snip]... I've been answering your question while assuming the mysql... sure that would have bitten me had I been using JDBC or MySQL. ... (perl.dbi.users)
Re: SMP performance degradation with sysbench ...Linux versions on that machine. ... I've reproduced this on a 8-socket/16-way dual core Opteron.... I am seeing is that MySQL is having trouble putting enough load into the ... seems to be what the clients and server threads use to communicate with. ... (Linux-Kernel)
Re: Q: Problem figuring out versions of DBI ... > The reason why I'm trying to figure out my DBI version is so that I ... > version of MySQL that I have installed. ... To get the available drivers,... You're trying to install DBD::mysql on a machine that does ... (comp.lang.perl.misc)
