faqts : Computers : Programming : Languages : PHP : Database Backed Sites : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

25 of 27 people (93%) answered Yes
Recently 10 of 10 people (100%) answered Yes

Entry

Why won't AUTO_INCREMENT increment past 10?

Jul 2nd, 1999 21:18
Jacob Stetser,


You've used a mixed or non-numeric data type for the AUTO_INCREMENTed 
column. You'll need to use a numeric data type such as TINYINT, 
SMALLINT, INT or BIGINT in order to get AUTO_INCREMENTed values beyond 
10