Insert sequential number in MySQL

December 21, 2023 by Tarik

Run the following queries to have incremented value in yourField column:

SELECT @i:=0;
UPDATE yourTable SET yourField = @i:=@i+1;