How to replace id in bulk in mysql?

S

siroper2020-04-20 19:17:43

MySQL

siroper, 2020-04-20 19:17:43

Hello. Is in the table of 1000 lines (id primary).
It turned out that I need to set id #1 for the 1000th line, and id #1000 for the first line, and so on ...
How can I do this using simple methods?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

I

idShura, 2020-04-21
@idShura

It turned out that I need to set id #1 for the 1000th line, and id #1000 for the first one, and so on...

You are doing some crazy stuff! Very interesting, why is this necessary?