have a table CREATE TABLE `pics2003` ( `ID` int(11) NOT NULL auto_increment, `Title` varchar(255) NOT NULL default '', `ShortDesc` text, `LongDesc` text, `Image` varchar(255) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM; and after a while someone wanted something that would always be first in the table when ordered, so i added the entry to it and edited the id to be -1. now whenever anything is added to the table it gets an id of 2147483647
how do i fix it so that it start the auto_increment at the correct spot again? (i am probably going to dump an re add the table for now, but in case i foobar it again at another time) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
