Re: auto_incement foobar

2003-07-11 Thread Keith C. Ivey
On 11 Jul 2003 at 15:41, Ray wrote: > 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

auto_incement foobar

2003-07-11 Thread Ray
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