Uhm, no, in general, databases don't store things in their insertion order. Some implementations of some databases might do so under certain conditions, but any code that relies on this should be considered buggy, even if it sometimes happen to generate the desired output - it might not the next time.

In general, if you have a database, and you want the data to be returned in a particular order, you must specify which order that is. If you want the "last" row or rows, you should reverse the order, which will reverse the order in which the rows are returned. So, if you want the last 20 lines, reverse the order, and finish your query after receiving 20 rows. These will be the last 20, in reverse order.

Note that I'm talking about databases in general. Particular database may use insertion order when being queried. But your question was phrased in general terms.

Abigail

In reply to Re: Retrieve last elements of a DB by Abigail-II
in thread Retrieve last elements of a DB by sulfericacid

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.