bachx Posted April 18, 2007 Share Posted April 18, 2007 I'm wondering if I can set my primary key, which is called 'id', to start incrementing from 1000 (or any number for that matter), instead of the default 1. Thanks in advance. Quote Link to comment Share on other sites More sharing options...
marcus Posted April 18, 2007 Share Posted April 18, 2007 ALTER TABLE `TABLENAME` AUTO_INCREMENT =1000 If you don't want to use that SQL query you can go into your PHPMyAdmin, select the database, select the table, hit the Operations tab on the top, scroll down a little, and change AUTO INCREMENT to 1000 Quote Link to comment Share on other sites More sharing options...
bachx Posted April 18, 2007 Author Share Posted April 18, 2007 Man, sometimes the answer is right infront of me, I just can't think straight. Thanks, that did it for me. Quote Link to comment 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.