17 messages in com.mysql.lists.win32Re: Auto-Increment
FromSent OnAttachments
Jill...@Aculab.com16 Jun 2003 02:49 
Armin Schöffmann16 Jun 2003 02:59 
Robin Keech16 Jun 2003 03:25 
Jill...@Aculab.com16 Jun 2003 03:28 
Jill...@Aculab.com16 Jun 2003 03:37 
Ignatius Reilly16 Jun 2003 03:38 
Ignatius Reilly16 Jun 2003 04:04 
Armin Schöffmann16 Jun 2003 04:08 
Armin Schöffmann16 Jun 2003 04:08 
Jill...@Aculab.com16 Jun 2003 04:09 
"Juan F. Capristán W."16 Jun 2003 04:14 
"Juan F. Capristán W."16 Jun 2003 04:20 
Jill...@Aculab.com16 Jun 2003 04:25 
Alan McDonald16 Jun 2003 04:27 
Robin Keech16 Jun 2003 05:15 
Ignatius Reilly16 Jun 2003 08:05 
Paul DuBois20 Jun 2003 21:12 
Subject:Re: Auto-Increment
From:"Juan F. Capristán W." (ju@editmaker.com)
Date:06/16/2003 04:14:13 AM
List:com.mysql.lists.win32

At 10:50 16/06/2003 +0100, Jill@Aculab.com wrote:

Suppose you have a table with an auto-incrementing int as primary key.

HOW can you (atomically) add a record to the table and find out what value has been assigned to the primary key of the newly added record?

Jill

Use "LAST_INSERT_ID() function.

Juan.