RE: Question about AUTO_INCREMENT

2002-10-23 Thread Romans Stepanovs
on to MySQL each time to execute query... Thanks again, Roman -Original Message- From: Ed Carp [mailto:erc@;pobox.com] Sent: Thursday, October 24, 2002 2:49 AM To: Romans Stepanovs; [EMAIL PROTECTED] Subject: RE: Question about AUTO_INCREMENT >From http://www.mysql.co

RE: Question about AUTO_INCREMENT

2002-10-23 Thread Ed Carp
>From http://www.mysql.com/doc/en/Miscellaneous_functions.html: LAST_INSERT_ID([expr]) Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column. See section 8.4.3.126 mysql_insert_id(). mysql> SELECT LAST_INSERT_ID(); -> 195 The last ID that was gener