"Duplicate entry ... " error on valid SQL

[eluser]drewbee[/eluser]
Yup. I have reserved tinyint's strictly for set choices IE 1,2,3,4,5 or for true or false (with 0 and 1); anything that is close to resembling an ID should be taken to atleast smallint.

I wonder if their is a script out their anywhere that checks column types and can compare it against its current value, and send out a nice little notification when it gets near a specified amount to reaching its max.

That would be cool.

I wonder what happens when you reach 18446744073709551615 (BIGINT);

I assume if that is an actual number... some company is doing really well!