03-10-2009, 11:03 PM
|
#6 (permalink)
|
|
Moderateur
Join Date: Apr 2007
Posts: 1,393
Thanks: 5
|
Quote:
Originally Posted by codeguy
Use a larger int (guessing image_id is tinyint) small int/medium int/int (i'd prolly recommend Int).
|
I'd also go with the unsigned tinyiny column theory. The tinyint (when unsigned) has a max value of 127. Trying to insert a new auto_incremented value higher than that will indeed raise the " Duplicate entry '127' for key 1". |
|
|
|