var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sort automatically after new insert
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.
Last edited by Panoy; 11-11-07 at 02:45.
Reason: made a wrong spelling on the title's caption
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