MySQL: Reset id column to auto increment from 1

reset_id_column.sql

-- 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;

Good

Awesome work. Thank you