Skip to main content

Reset ID Field in an mysql table (1,2,3,4…)

u need to use the following command in an mysql terminal.


-- your_table: The table to modify
-- id: The id field/column to reset

SET @num := 0;
UPDATE your_table SET id = @num := (@num+1);
ALTER TABLE your_table AUTO_INCREMENT =1;

(This code is taken from
http://www.daftspunk.com/code/how-to-reset-table-id-fields-1234-using-mysql.html)

Comments

Post a Comment

Popular posts from this blog

15 things that you should give up to be happy

1. Give up your need to always be right.  There are so many of us who can’t stand the idea of being wrong – wanting to always be right – even at the risk of ending great relationships or causing a great deal of stress and pain, for us and for others. It’s just not worth it. Whenever you feel the ‘urgent’ need to jump into a fight over who is right and who is wrong, ask yourself this question:  “Would I rather be right, or would I rather be kind?” Wayne Dyer. What difference will that make? Is your ego really that big? 2. Give up your need for control.  Be willing to give up your need to always control everything that happens to you and around you – situations, events, people, etc. Whether they are loved ones, coworkers, or just strangers you meet on the street – just allow them to be. Allow everything and everyone to be just as they are and you will see how much better will that make you feel. “By letting it go it all gets done. The world is won by those who let it...
Post a Comment
Read more

XAMPP: Couldn't start MySQL!

XAMPP: Couldn't start MySQL! Trying to run mysql on ubuntu 10.10 and give this vauge error "XAMPP: Couldn't start MySQL!" Try this 1. Open a terminal. 2. run this command sudo chown -hR root /opt/lampp 3. then run this sudo chmod -R 777 /opt/lampp 4. Now Restart XAMPP sudo /opt/lampp/lampp restart U are all set. And if u r getting the follwing warning after restarting "Warning: World-writable config file ‘/opt/lampp/etc/my.cnf’ is ignored" 1.Open terminal 2.Migrate to /opt/lampp/etc 3.run the command sudo chmod 755 my.cnf
15 comments
Read more