Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007

    Smile 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 03:45. Reason: made a wrong spelling on the title's caption

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    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 | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2007
    Now I know. Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts