Hi, I've a select with X records ... how Can I view (in the result) all
items without the first?? (X-1 records ... not the first record)

Thanks

luca schreef:
> Hi, I've a select with X records ... how Can I view (in the result) all
> items without the first?? (X-1 records ... not the first record)
>
> Thanks


LIMIT
(more info at: http://dev.mysql.com/doc/refman/5.0/en/select.html)

--
Luuk

Thanks but I don't know the value of the limit

luca schreef:
> Thanks but I don't know the value of the limit


from the page i mentioned, but you cut-away:
The LIMIT clause can be used to constrain the number of rows returned by
the SELECT statement. LIMIT takes one or two numeric arguments, which
must both be non-negative integer constants (except when using prepared
statements).
With two arguments, the first argument specifies the offset of the first
row to return, and the second specifies the maximum number of rows to
return. The offset of the initial row is 0 (not 1):
SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15


so, you have to do something like:
SELECT * FROm <table> LIMIT 1,9999999999;
and you'll get all records except the first one.




--
Luuk

On Oct 4, 12:18 pm, Luuk <L...@invalid.lan> wrote:
> luca schreef:
>
> > Thanks but I don't know the value of the limit
>
> from the page i mentioned, but you cut-away:
> The LIMIT clause can be used to constrain the number of rows returned by
> the SELECT statement. LIMIT takes one or two numeric arguments, which
> must both be non-negative integer constants (except when using prepared
> statements).
> With two arguments, the first argument specifies the offset of the first
> row to return, and the second specifies the maximum number of rows to
> return. The offset of the initial row is 0 (not 1):
> SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15
>
> so, you have to do something like:
> SELECT * FROm <table> LIMIT 1,9999999999;
> and you'll get all records except the first one.

Note that you must have an ORDER BY for this to be very useful.

>
> --
> Luuk

toby schreef:
> On Oct 4, 12:18 pm, Luuk <L...@invalid.lan> wrote:
>> luca schreef:
>>
>>> Thanks but I don't know the value of the limit
>> from the page i mentioned, but you cut-away:
>> The LIMIT clause can be used to constrain the number of rows returned by
>> the SELECT statement. LIMIT takes one or two numeric arguments, which
>> must both be non-negative integer constants (except when using prepared
>> statements).
>> With two arguments, the first argument specifies the offset of the first
>> row to return, and the second specifies the maximum number of rows to
>> return. The offset of the initial row is 0 (not 1):
>> SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15
>>
>> so, you have to do something like:
>> SELECT * FROm <table> LIMIT 1,9999999999;
>> and you'll get all records except the first one.
>
> Note that you must have an ORDER BY for this to be very useful.
>

true

--
Luuk