Hi,
I have a database with the following table and data:
When I add a new record the auto_increment number becomes '2147483647'
not sure why? Checked the SHOW TABLE STATUS too and this shows that the
next auto_increment number will be '2147483647' anyone know why?
Running MySQL 3.23.41
Regards,
Bobby
DROP TABLE IF EXISTS `ACCategories`;
CREATE TABLE `ACCategories` (
`ACCategoriesID` int(11) NOT NULL auto_increment,
`Description` varchar(255) NOT NULL default '',
`EmailSent` int(11) NOT NULL default '0',
PRIMARY KEY (`ACCategoriesID`)
) TYPE=MyISAM;
INSERT INTO `ACCategories` VALUES (2, 'Work Permits', 2); INSERT INTO
`ACCategories` VALUES (1, 'Intellectual Property', 2);
INSERT INTO `ACCategories` VALUES (-1, 'Category not required', 2);
INSERT INTO `ACCategories` VALUES (3, 'Trade & Investment', 2);
INSERT INTO `ACCategories` VALUES (8, 'US SADC Business Council', 2);
INSERT INTO `ACCategories` VALUES (5, 'OSAC', 2);
INSERT INTO `ACCategories` VALUES (6, 'Africa Growth and Opportunity Act
(AGOA)', 2);
INSERT INTO `ACCategories` VALUES (7, 'HIV/AIDS', 2);
INSERT INTO `ACCategories` VALUES (9, 'Black Empowerment', 2);
INSERT INTO `ACCategories` VALUES (10, 'Legislation', 2);
INSERT INTO `ACCategories` VALUES (11, 'Government Working Committees',
2);
INSERT INTO `ACCategories` VALUES (12, 'Export - Import', 2);
INSERT INTO `ACCategories` VALUES (13, 'US Visas Applications', 2);
INSERT INTO `ACCategories` VALUES (14, 'Africa Update', 2);
INSERT INTO `ACCategories` VALUES (15, 'Public Relations', 2);
INSERT INTO `ACCategories` VALUES (16, 'Technology', 2);
INSERT INTO `ACCategories` VALUES (17, 'Environmental', 2);
INSERT INTO `ACCategories` VALUES (18, 'Department of Trade & Industry',
2);
INSERT INTO `ACCategories` VALUES (19, 'Government Meetings', 2);
INSERT INTO `ACCategories` VALUES (20, 'Parliamentary Reports', 2);
INSERT INTO `ACCategories` VALUES (-2, 'Important Message for All', 2);
INSERT INTO `ACCategories` VALUES (21, 'US Chamber of Commerce -
Washington', 2);
INSERT INTO `ACCategories` VALUES (22, 'Trade & Industry', 2);
INSERT INTO `ACCategories` VALUES (23, 'South African Economic News',
2);
INSERT INTO `ACCategories` VALUES (24, 'Alert', 2);
INSERT INTO `ACCategories` VALUES (25, 'American Society - Newsletter',
2);
INSERT INTO `ACCategories` VALUES (26, 'International Business', 2);
INSERT INTO `ACCategories` VALUES (27, 'World Summit', 2);
INSERT INTO `ACCategories` VALUES (28, 'CitiChat - Weekly publication
concerning cities', 2);
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
