Hi, I have been wondering about this problem for some time now:
If I have a table with an AUTO_INCREMENT field with the type of TINYINT, what will happen if a value in that field exceed 255 (or the capacity for that field). Will that field reset and start from 0 again? If it don't, how can any application running for a long time if an AUTO_INCREMENT will sooner or later exceed the capacity for the field?
Thanks for any help
Peter
If I have a table with an AUTO_INCREMENT field with the type of TINYINT, what will happen if a value in that field exceed 255 (or the capacity for that field). Will that field reset and start from 0 again? If it don't, how can any application running for a long time if an AUTO_INCREMENT will sooner or later exceed the capacity for the field?
Thanks for any help
Peter