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

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

Difference between is_file and file_exists

If you want to know that the argument supplied is a file or not use is_file() file_exists() will take both file and directory as input and return true if they exists. So, unless you specifically want to check if the argument passed is a file use is_file otherwise use file_exists()
1 comment
Read more