On 9/26/2006 4:02 PM, Dan Buettner wrote: > Jorrit, it's a known behavior, not a bug. > > Recent versions of MySQL will, when given a zero (0) as a value for an > auto incrementing identity column, simply fill in the next auto > incrementing value ... unless you flip a switch to specifically tell > it not to do that ... see: > http://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html and look > for NO_AUTO_VALUE_ON_ZERO > > HTH, > Dan > >
Dan, That explains it! I see the NO_AUTO_VALUE_ON_ZERO in the dump as well. Thanks! Jorrit -- System Developer Infopact Network Solutions Hoogvlietsekerkweg 170 3194 AM Rotterdam Hoogvliet tel. +31 (0)88 - 4636700 fax. +31 (0)88 - 4636799 mob. +31 (0)6 - 14105968 [EMAIL PROTECTED] http://www.infopact.nl/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]