UPDATE altas JOIN (SELECT @suma:=0) T1 SET createdon = DATE_ADD(createdon, INTERVAL SECOND (@suma:= @suma+10));