Mysql query to make one field sequence number?

Mysql query to make one field sequence number? Suppose there are 5000 records, ID are different and not in order.. as can be done in a certain field was the ordinal? 1.2.3.4.5 and dt.
July 9th 19 at 10:20
1 answer
July 9th 19 at 10:22
Create additional field and write to a serial number. What's the problem?
The fact that the field is, but I have to massively write down the sequence number. - Caroline.Herzog commented on July 9th 19 at 10:25
SET @id = 1;
UPDATE `table` SET `field` = @id, @id := @id+1 ORDER BY ...
- Kenyatta commented on July 9th 19 at 10:28

Find more questions by tags MySQL