Oblivion Knight
05-11-2004, 11:33 AM
It appears that I can't have a NULL value for phrasegroupid since it's a PRIMARY field..
The phrasegroupid jumps from 150 to 1000, if I wanted to insert a phrasegroup at the next available slot, say 151 - in my case the next available slot would be 153, since the hacklog and mtprofilepictures have 151 and 152..
How would I do it without a NULL value and setting the id to 151/153 manually?
This is the query currently, and obviously it won't run correctly..
INSERT INTO `phrasetype` (`phrasetypeid`, `fieldname`, `title`, `editrows`) VALUES (NULL, `journals`, `Journals`, `3`);
The phrasegroupid jumps from 150 to 1000, if I wanted to insert a phrasegroup at the next available slot, say 151 - in my case the next available slot would be 153, since the hacklog and mtprofilepictures have 151 and 152..
How would I do it without a NULL value and setting the id to 151/153 manually?
This is the query currently, and obviously it won't run correctly..
INSERT INTO `phrasetype` (`phrasetypeid`, `fieldname`, `title`, `editrows`) VALUES (NULL, `journals`, `Journals`, `3`);