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
------------------------------------------------------------------------------
