sasori Posted September 6, 2008 Share Posted September 6, 2008 what should i do? i have this data in my phone table ,uid,fname,lname,phone ,1,jena,malone,234325 when i delete that data with uid ='1' then input the same data, the uid increments + 1..what should i do in order to make the new data as no. 1 ? because even if i update table and set uid as 1. the next data input will be 3 and not 2 Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted September 6, 2008 Share Posted September 6, 2008 I presume your uid column is set as auto_increment, then what you're tying to do is not possible. What is the purpose for this? Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted September 6, 2008 Share Posted September 6, 2008 I always wonder why people want linear counting on their PKs when it isn't useful Quote Link to comment Share on other sites More sharing options...
Zane Posted September 6, 2008 Share Posted September 6, 2008 you'll have to truncate your table Quote Link to comment Share on other sites More sharing options...
sasori Posted September 6, 2008 Author Share Posted September 6, 2008 case solved...thanks for replies. 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.