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 Link to comment https://forums.phpfreaks.com/topic/122982-solved-change-of-index-help/ 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? Link to comment https://forums.phpfreaks.com/topic/122982-solved-change-of-index-help/#findComment-635219 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 Link to comment https://forums.phpfreaks.com/topic/122982-solved-change-of-index-help/#findComment-635312 Share on other sites More sharing options...
Zane Posted September 6, 2008 Share Posted September 6, 2008 you'll have to truncate your table Link to comment https://forums.phpfreaks.com/topic/122982-solved-change-of-index-help/#findComment-635318 Share on other sites More sharing options...
sasori Posted September 6, 2008 Author Share Posted September 6, 2008 case solved...thanks for replies. Link to comment https://forums.phpfreaks.com/topic/122982-solved-change-of-index-help/#findComment-635498 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.