Hey there. I was wondering how i can clean up my database so the rows will be sorted by ID? so it's 1,2,3,4 etc. right now the rows are sorted totaly random like 758,1,3487,3,4 etc. i hope someone can help, thanks!
how are they inserted? and what is your database type? if its MyISAM and you have a primary key thats auto increment, it should have done so already
copyed one of the rows, and that is how they are inserted. the database type should be INNODB as mysql administrator said so.
Why are you wanting to reorder what is in your database? If you just want to order that information as it comes out just use DESC and ASC
this is not a query for a php files i ask for, this is a query for my database to use in like phpmyadmin to sortup the database. atm i goes from 1-700 then comes 1000-2000 and then 800-999 then 2001 and so on, i want it to be in the correct nummeral order if you understand what i mean.
If you are browsing in phpmyadmin, you can click on a column heading and the rows will be sorted according to that column. You can also select the sort order during search.