flemingmike Posted September 22, 2010 Share Posted September 22, 2010 hello, 2 questions 1, can i set the auto increment to start at 1400 instead of number 1? 2, if i have a field that is auto increment, can i insert a number into that field if i want also? for instance, the next auto number is 1420, but i want to use number 1200. thanks! Quote Link to comment Share on other sites More sharing options...
Mchl Posted September 22, 2010 Share Posted September 22, 2010 1. yes ALTER TABLE yourTable AUTO_INCREMENT = 1400 2. yes, but be careful with that 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.