Guest kilbad Posted February 22, 2007 Share Posted February 22, 2007 I am setting up a table and wanted to know the syntax to create it so that there is an initial arbitrary 10 digit primary ID key on the first entry, that then auto increments with each additional entry. Currently, I have: id INT NOT NULL PRIMARY KEY AUTO_INCREMENT which results in the key starting at one. Any ideas? Thank you all so much in advance! Brendan Quote Link to comment https://forums.phpfreaks.com/topic/39569-solved-setting-up-table-with-initial-10-digit-primary-id-key-that-then-autoincrements/ Share on other sites More sharing options...
Guest kilbad Posted February 22, 2007 Share Posted February 22, 2007 I added the following line after the table creation:: mysql_query("ALTER TABLE table AUTO_INCREMENT = 1000000000;") or die(mysql_error()); Quote Link to comment https://forums.phpfreaks.com/topic/39569-solved-setting-up-table-with-initial-10-digit-primary-id-key-that-then-autoincrements/#findComment-190964 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.