Im using JSP, MySql and Mysql Control Center.
I'm a newbie of databases and got (I think) two simple questions.
I want to sort my table by "rank". In MySql Controll Center there is an option "Order By" , under Alter Table Option, which I have set to "rank".
My questions are:
1) Everytime I edit my table I have to set "Order By" to rank because "Order By" is set to "Default", why does this occur?
2) When I do an INSERT (a new row) it wont come last in my table even if "rank" is bigger. Should I write something special in my syntax if I want to order my table by "rank" when I do an INSERT, why is there an option "Order By" if it doesn't work? Or is that for something else?