Setting a new value to a field with an auto_increment attrib
Posted: Mon Feb 19, 2007 3:15 am
I'm trying to design an internet forum these days ...
In my database i have got a field called (ID) of type integer which represents the id of the topics and i have assigned it an (auto_increment) attribute...
My problem is that when i delete all the topics from the forum and after that add a new topic to the database the (ID) of that new topic continues to increment from the last deleted topic,
so how can i set the (ID) of the new topic to 1 in case all the previous topics were deleted?
In my database i have got a field called (ID) of type integer which represents the id of the topics and i have assigned it an (auto_increment) attribute...
My problem is that when i delete all the topics from the forum and after that add a new topic to the database the (ID) of that new topic continues to increment from the last deleted topic,
so how can i set the (ID) of the new topic to 1 in case all the previous topics were deleted?