Hello, I have got a database. it has got only one table and table has got 7 fields. I have got an id field which is set to auto_increment. Can I randomize this database and save the database the way it is after randomized? I tried with phpmyadmin but i can not do it. I sort it by another field rather than id and try to export but it goes back to old way.
select all fields but the ID one when you sort it, export it and then import it with a fresh new id auto increment field, or better yet use a php function to do that with a counter variable for the id.