On Wed, 2010-02-03 at 00:21 +0100, Rene Veerman wrote: > the auto_increment sytnax is not uniform across servers, is it? > > On Wed, Feb 3, 2010 at 12:11 AM, Ashley Sheridan > <ash@xxxxxxxxxxxxxxxxxxxx>wrote: > > > I saw it happen on a site that was getting only about 3000 hits a day. It > > just takes the right combination of circumstances and it all goes pear > > shaped. You really should get out of the habit of doing it. > > It is a MySQL only function. MSSQL has @@IDENTITY, not sure how other engines implement it. Thanks, Ash http://www.ashleysheridan.co.uk