On Fri, 9 Nov 2001, Carl Troein wrote:
> Date: Fri, 09 Nov 2001 15:41:21 GMT
> From: Carl Troein <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Beginner question - getting last inserted ID
>
>
> Anna Åhnberg writes:
>
> > Thanks, I actually already found the chapters but now I also now how to
> > use the function too!
>
> Let me quote from the manual:
> "LAST_INSERT_ID([expr])
> Returns the last automatically generated value that was
> inserted into an AUTO_INCREMENT column.
> mysql> select LAST_INSERT_ID();
> -> 195"
>
> Thus you'd follow these steps:
> 1) INSERT into the table, and leave out the auto column or supply
> a value of 0 or NULL
> 2) Verify that the query succeeded
> 3) SELECT LAST_INSERT_ID()
> 4) Get the result of the SELECT. On success, the SELECT will
> return one row with one value in it. That is the number you're
> interested in knowing.
If you are using the mmysql jdbc driver you can directly access it.
use
import org.gjt.mm.mysql.Statement;
instead of "java.sql.Statement;"
Then after the insert
long id = stmt.getLastInsertID();
Note: this is the only method to get a bigint unsigned index back
accordign to the mm.mysql doc's . See source forge for details.
>
> If you were using MySQL's C API there is a function that returns
> the ID without the need for steps 3-4, but since you are
> communicating over JDBC I don't think there's a simpler solution
> available. The query in step 3 is extremely fast, so it doesn't
> really matter, except that it's a bit more work to make an extra
> query.
>
> //C
>
> --
> Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
> [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
> Amiga user since '89, and damned proud of it too.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
