Hi to all,

Is it possible in MySQL or perhaps in any existing RDBS that can automaticall sort a table in ascending order after you have just inserted a new record?

I want to know if there are features such as this which is found not only in MySQL but also to other existing RDBMS.

Thanks and god bless all.

no, tables don't work like that

it's like people entering a room for a cocktail party -- they don't automatically line themselves up in ascending order, they go where they want to go

if you want the people to arrange themselves in ascending order, the first thing you have to do is tell them ascending order by what -- IQ, age, height in millimetres, whatever

in relational tables, the rows in a table have no order

if you want them in a particular order, you can achieve this only using the ORDER BY clause in a SELECT statement

Now I know. Thanks again