ChompGator Posted August 14, 2008 Share Posted August 14, 2008 Hey, I have a Join form that now works, however when a user joins PHP and SQL generate the ID numbers. So naturally the first number is 1. - I would like to give SQL a query in the SQL section of the table that tells it to start numbering at 100, not 1 Does anyone know of a script that will allow me to do this...I used to have the SQL script that did this, but I miss placed it .. Thanks, Quote Link to comment https://forums.phpfreaks.com/topic/119673-sql-start-increment-100/ Share on other sites More sharing options...
pocobueno1388 Posted August 14, 2008 Share Posted August 14, 2008 You can manually insert a record and set the ID as 100, then it will go up from there...if that would be an option for you. Quote Link to comment https://forums.phpfreaks.com/topic/119673-sql-start-increment-100/#findComment-616538 Share on other sites More sharing options...
ChompGator Posted August 14, 2008 Author Share Posted August 14, 2008 Ill try it, and post here if it doesn't work. Quote Link to comment https://forums.phpfreaks.com/topic/119673-sql-start-increment-100/#findComment-616541 Share on other sites More sharing options...
wildteen88 Posted August 14, 2008 Share Posted August 14, 2008 You can also do ALTER TABLE AUTO_INCREMENT=100 Quote Link to comment https://forums.phpfreaks.com/topic/119673-sql-start-increment-100/#findComment-616543 Share on other sites More sharing options...
ChompGator Posted August 14, 2008 Author Share Posted August 14, 2008 yep just figured that out a short while ago thanks so much for all the help Quote Link to comment https://forums.phpfreaks.com/topic/119673-sql-start-increment-100/#findComment-616562 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.