how to update mysql table, i want to regenerate serial no for existing table

UPDATE tableName, (SELECT @id := 0) dm
SET sale_id = (@id := @id + 1)