update table by incrementing value in mysql

to update the table with the incremented number in mysql, you can use the following concept,
 

SET @strtVal = 0;
UPDATE table SET fieldname=(@strtVal := @strtVal+1) ;