add prefix in table field in MySql

SET @rank:=0;
Update`employee` set email= CONCAT(@rank:=@rank+1,email) WHERE email='demo@mail.com'

upadate rows by increcremental value in MySql

SET @rank:=0;
update T
set Number=@rank:=@rank+1