Professional Web Applications Themes

SELECT query with negative LIMIT? - MySQL

Is possible execute the query below: SELECT * FROM table LIMIT -10 I need extract the last 10 rows inserted in table. That query running? Thank you for all antoniog...

  1. #1

    Default SELECT query with negative LIMIT?

    Is possible execute the query below:

    SELECT * FROM table LIMIT -10

    I need extract the last 10 rows inserted in table.

    That query running?

    Thank you for all

    antoniog
    antoniog Guest

  2. #2

    Default Re: SELECT query with negative LIMIT?

    antoniog wrote: 

    Use an auto_increment column and sort DESC then use limit 10


    Paul Guest

  3. #3

    Default Re: SELECT query with negative LIMIT?

    antoniog <com> wrote:
     

    Hmmz, I assume there's some way the 'last rows' can be selected by a
    field, either a unique incrementing 'id', or some sort of 'add_time'

    SELECT * FROM TABLE ORDER BY id DESC LIMIT 10

    --
    Rik Wasmus
    Posted on Usenet, not any forum you might see this in.
    Ask Smart Questions: http://tinyurl.com/anel
    Rik Guest

  4. #4

    Default Re: SELECT query with negative LIMIT?

    Thank you

    I will try it

    Paul Lautman ha scritto: 
    >
    > Use an auto_increment column and sort DESC then use limit 10
    >
    >[/ref]
    antoniog Guest

  5. #5

    Default Re: SELECT query with negative LIMIT?

    Thank you

    I will try it

    Rik ha scritto: 
    >
    > Hmmz, I assume there's some way the 'last rows' can be selected by a
    > field, either a unique incrementing 'id', or some sort of 'add_time'
    >
    > SELECT * FROM TABLE ORDER BY id DESC LIMIT 10
    >
    > --Rik Wasmus
    > Posted on Usenet, not any forum you might see this in.
    > Ask Smart Questions: http://tinyurl.com/anel[/ref]
    antoniog Guest

Similar Threads

  1. SELECT...LIMIT that does a partial select?
    By Ignoramus24559 in forum MySQL
    Replies: 6
    Last Post: December 17th, 04:02 PM
  2. help with ORBER BY in my query when negative numbers areinvolved
    By happysailingdude in forum Coldfusion - Getting Started
    Replies: 6
    Last Post: May 25th, 11:28 PM
  3. Negative SELECT in mysql?
    By kaptain in forum PHP Development
    Replies: 12
    Last Post: January 16th, 07:25 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139