Primary Index Order

[ned911]

Have a table with a primary index (entry_id). Had to insert some data from a CSV file now my entry_id is no longer in sequential order ie - 1,2,3,4,10,5,8,7,6

Is there a way to get the table ordered sequentially by entry_id while browsing in phpmyadmin?

Ned

[Drakla]

you have to tell it to order by id in the query, so

SELECT * FROM table ORDER BY entry_id;

Or you can click on the column name and it'll sort by what you click on, and put one of them uppy/downy arrows there.

[ned911]

Or that drop down box that says Order By, select primary key and wallah.

Drakla,

Thanks for the help I would never have noticed the drop down had you not pointed me to click on the column heading.

Ned