I am doing an experiment, to randomize the id's from a table, because I will need this in future for security purposes.
For example, If I have records from id=1 to id=10. Now I want that their serial id numbers will get randomize, like id=1 become 6 and id=2 become 1, etc. in a randomize manner.
Can anyone tell me any idea or mysql command for this?