score:0

Try something like the following:

$result=mysql_query("select * from my_table");

$counter =1;

while($row = mysql_fetch_assoc($result)){
 //suppose $row['id'] is your current primary key
 mysql_query("update my_table set ticker_id=$counter where id=".$row['id']);
$counter++;
}

More questions

More questions with similar tag