> Chris Bolt wrote:
>
> > Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
> > tables will give you "Duplicate entry" errors if you hit the maximum.
>
> I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
> ISAM tables also returned a "Duplicate entry" error when I hit
> the max. Was this "feature" eliminated?
I missed the start of this discussion, but maybe the following
explains what's going on...
http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_5_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq