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. Link to comment https://forums.phpfreaks.com/topic/47602-solved-sql-question/ 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 Link to comment https://forums.phpfreaks.com/topic/47602-solved-sql-question/#findComment-232399 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. Link to comment https://forums.phpfreaks.com/topic/47602-solved-sql-question/#findComment-232403 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.