mySQL Insert Problem

[kamy99]

Hi all:

Suddenly I have a problem out of the blue!!:eek: :eek: :eek:

I have a product table in mySQL, it has many fields and ALL was working fine.

DROP TABLE IF EXISTS Products;
CREATE TABLE Products (
ProductID int(11) NOT NULL auto_increment,
ProductName varchar(250) NOT NULL default '',
PRIMARY KEY (ProductID),
FULLTEXT KEY ProductName (ProductName)
) TYPE=MyISAM COMMENT='Main Products ' AUTO_INCREMENT=2147483650 ;

I see one problem here: AUTO_INCREMENT=2147483650 ;
What is that? Where does it come from? More importantly how can I get rid of it?

I try inserting data , through phpMyadmin, but keep getting the following error:

#1062 - Duplicate entry '2147483647' for key 1
FYI: The insertion won't work because of that error!!

The first 295 entries in to the db, whether through phpmyadmin or my own application, worked just fine.

Any ideas?

Thanx
Kamy

[zingbats]

autoincrement is a generated number. Therefore u cannot define it

[kamy99]

yes I'm well aware of the characteristics of auto_increment.
I think the issue has something to do with integer range , as specified here:

http://www.mysql.com/doc/en/Numeric_types.html

However, I didn't really grasp it.:o :o

It says Integer has a range between -2147483647 to 2147483647 .
I only have 167 entries in the db.

ideas?

[kamy99]

anyone? Anything??