eduard Posted May 9, 2012 Share Posted May 9, 2012 Although this topic doesn´t belong here, how do I reset my ´id´ to 0 in phpmyadmin? I´ve been trying with Google without success! Link to comment Share on other sites More sharing options...
Ingolme Posted May 9, 2012 Share Posted May 9, 2012 I don't know what "id" is. Is this a field in a database table? Link to comment Share on other sites More sharing options...
divinedesigns1 Posted May 9, 2012 Share Posted May 9, 2012 Although this topic doesn´t belong here, how do I reset my ´id´ to 0 in phpmyadmin? I´ve been trying with Google without success! in the phpmyadmin, in the id row you need to have it as id 11 auto_increment primary, that will make it start from 0 and add 1 to that number pre person or w.e your trying to do now if you already done that, reseting it in phpmyadmin, i dont believe that is possible, would have to re-create the database for it to start once again from 0 "might be wrong who knows" Link to comment Share on other sites More sharing options...
justsomeguy Posted May 9, 2012 Share Posted May 9, 2012 You can change the auto-increment value on the Operations tab. Link to comment Share on other sites More sharing options...
eduard Posted May 9, 2012 Author Share Posted May 9, 2012 I don't know what "id" is. Is this a field in a database table? Yes (sorry!) Link to comment Share on other sites More sharing options...
eduard Posted May 9, 2012 Author Share Posted May 9, 2012 You can change the auto-increment value on the Operations tab. But where?- table options- table maintenance- move table to ....- etc. Link to comment Share on other sites More sharing options...
thescientist Posted May 9, 2012 Share Posted May 9, 2012 But where?- table options- table maintenance- move table to ....- etc. while browsing the table in question Link to comment Share on other sites More sharing options...
justsomeguy Posted May 9, 2012 Share Posted May 9, 2012 There aren't a lot of things on the Operations tab, Eduard. Are you trying to move or copy the table? No, you're not. Do you want to defragment, optimize, or flush the table? No, that doesn't sound like what you're trying to do either. Maybe you want to change one of the options. Link to comment Share on other sites More sharing options...
eduard Posted May 9, 2012 Author Share Posted May 9, 2012 (edited) There aren't a lot of things on the Operations tab, Eduard. Are you trying to move or copy the table? No, you're not. Do you want to defragment, optimize, or flush the table? No, that doesn't sound like what you're trying to do either. Maybe you want to change one of the options. I did that, but it didn´t work!I got the ´id´ at 0 (unmarked auto-increment), but I want it ascending (1, 2, 3, 4) from 1!How? Edited May 9, 2012 by eduardlid Link to comment Share on other sites More sharing options...
justsomeguy Posted May 9, 2012 Share Posted May 9, 2012 It needs to be an auto-increment field if you want it to auto-increment, Eduard. Link to comment Share on other sites More sharing options...
eduard Posted May 9, 2012 Author Share Posted May 9, 2012 It needs to be an auto-increment field if you want it to auto-increment, Eduard. But now the numbers are 69, 70, etc.. How do I start from 1 again? Link to comment Share on other sites More sharing options...
thescientist Posted May 9, 2012 Share Posted May 9, 2012 (edited) didn't we just tell you how to reset it? In the Operation Tab..? Edited May 9, 2012 by thescientist Link to comment Share on other sites More sharing options...
birbal Posted May 9, 2012 Share Posted May 9, 2012 But now the numbers are 69, 70, etc.. How do I start from 1 again? you can truncate the table (there is option for that named EMPTY). but it will delete all the data. Link to comment Share on other sites More sharing options...
eduard Posted May 9, 2012 Author Share Posted May 9, 2012 (edited) I´ll do it how thescientist said (wipe the table - I also read that!) Thanks for the explanation!How do I do it safe? Another question:Is it better to have phpmyadmin in the cPanel of my hosting company? Edited May 9, 2012 by eduardlid Link to comment Share on other sites More sharing options...
birbal Posted May 9, 2012 Share Posted May 9, 2012 Is it better to have phpmyadmin in the cPanel of my hosting company?they already have. when you login in your CP look for it. Link to comment Share on other sites More sharing options...
dsonesuk Posted May 9, 2012 Share Posted May 9, 2012 I´ll do it how thescientist said (wipe the table - I also read that!) Thanks for the explanation!How do I do it safe? I see dodo and a fan coming to mind here....please make backup. Question WHY reset the ID,? you are not going to run out of numbers, it does not matter if they are in the wrong order, or don't run in sequence, or have gaps, as you WILL ALWAYS end up with this situation as rows of data are deleted and replaced. The only reason someone would do this is, is if they have a serious OCD problem, and can't function/sleep unless the id runs in a orderly sequence starting from 1. Link to comment Share on other sites More sharing options...
eduard Posted May 9, 2012 Author Share Posted May 9, 2012 I´ll do it how thescientist said (wipe the table - I also read that!) Thanks for the explanation!How do I do it safe? I see dodo and a fan coming to mind here....please make backup. Question WHY reset the ID,? you are not going to run out of numbers, it does not matter if they are in the wrong order, or don't run in sequence, or have gaps, as you WILL ALWAYS end up with this situation as rows of data are deleted and replaced. The only reason someone would do this is, is if they have a serious OCD problem, and can't function/sleep unless the id runs in a orderly sequence starting from 1. Why reset ´id´? I think the client doesn´t like to have an ´id´ starting with 69! Link to comment Share on other sites More sharing options...
dsonesuk Posted May 10, 2012 Share Posted May 10, 2012 You think? So you are wasting time trying to reset a auto incrementing id value, that no-one would even consider bothering with? where 99.9999999% of time the client would not even know what a auto incrementing id value is and probably couldn't care less, as long as the site works as it should, ALL based on a assumption. Link to comment Share on other sites More sharing options...
eduard Posted May 10, 2012 Author Share Posted May 10, 2012 You think? So you are wasting time trying to reset a auto incrementing id value, that no-one would even consider bothering with? where 99.9999999% of time the client would not even know what a auto incrementing id value is and probably couldn't care less, as long as the site works as it should, ALL based on a assumption. Ok, thamks! Link to comment Share on other sites More sharing options...
thescientist Posted May 10, 2012 Share Posted May 10, 2012 do you understand what an auto incrementing id is used for? It's just used to keep the records unique. it has really no influence on the content to be stored in the table. i.e. it's like it has to be product number (id) or anything. It's internal to the database and your schema. Link to comment Share on other sites More sharing options...
eduard Posted May 10, 2012 Author Share Posted May 10, 2012 do you understand what an auto incrementing id is used for? It's just used to keep the records unique. it has really no influence on the content to be stored in the table. i.e. it's like it has to be product number (id) or anything. It's internal to the database and your schema. Sorry, but 2 things are more important now:- uploading files to my host and msql queries on my website! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now