Pas facile de trouver les limites dans la doc :-(( :
"When an AUTO_INCREMENT column runs out of values, InnoDB wraps a
BIGINT to -9223372036854775808 and BIGINT UNSIGNED to 1.
However, BIGINT values have 64 bits, so do note that if you were to
insert one million rows per second, it would still take nearly three
hundred thousand years before BIGINT reached its upper bound."
[^] # Re: Doc MySQL en ligne
Posté par zx81 . En réponse au message nombre d'enregistrement mysql. Évalué à 1.
"When an AUTO_INCREMENT column runs out of values, InnoDB wraps a
BIGINT to -9223372036854775808 and BIGINT UNSIGNED to 1.
However, BIGINT values have 64 bits, so do note that if you were to
insert one million rows per second, it would still take nearly three
hundred thousand years before BIGINT reached its upper bound."