Re-index primary key in Mysql database table

set @ROW = 0;

UPDATE `visitorhistory` SET `id` = @ROW := @ROW+1 ORDER BY `id` ASC;