From: Oliver Artelt Date: March 15 1999 12:43pm Subject: Re: Auto-Increment List-Archive: http://lists.mysql.com/mysql/247 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Sun, 14 Mar 1999, Tauren Mills wrote: > > > After reading the manual, I have a question about Auto-Increment... > > The manual says that I can use this query to find out the value of the most > recent AUTO_INCREMENT field: > > SELECT * FROM tbl_name WHERE auto_col IS NULL > Lock the table before your INSERT and SELECT statement. Another way is to stamp the rows yourself, e.g. functions related to RPC. oli. ------------------------------------------------------------------------------ Oliver Artelt Jordanstr.7, 39112 Magdeburg mailto:oli@stripped Tel: 0391-6112827 Fax: 0391-604243 ------------------------------------------------------------------------------ http://www.transnet.de ISP: Wir schaffen Verbindungen! http://www.magdeburg-online.de Die Magdeburger Online-Information ------------------------------------------------------------------------------