Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Autonumber Issue

Status
Not open for further replies.

frumunda

Technical User
Jul 9, 2002
6
US
Once the database is incremented to 127 entries the database no longer increments. As a result I get a 127 error. Does anyone know how to get around this?
 
It sounds to me that you're using a TINYINT columntype for your auto_increment column. TINYINT can take values from -128 to 127. TINYINT UNSIGNED can take values from 0 to 255.

Alter the table so that the auto_increment column is wider. See the MySQL online documentation entries for Numeric types and ALTER TABLE


Want the best answers? Ask the best questions!

TANSTAAFL!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top