This is a theoretical question from someone(me) who is new to databases and new to mySQL
Lets say, that I have created a very simple table. It has 2 fields; id(auto) and fruits. Now the order of the fruits is important. So, lets say we have 10 different fruits in the table, and suddenly we find some grapes, and we want to insert them as the forth most important.
What is the best way to do this? Every way that I think of seems to be kinda of a stupidly long way round. Is there a tried an true method?
Any help appreciated