Hello!

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?

Thanks for helping me!

You might want to check in the MySQL Forum...


http://www.dbforums.com/f5/

This is already the MySQL-forum, isn't it?

I also thougt that ?!?