Re: MySQL 5.0 a LIMIT

From: Jiří Hrazdil <konference (zavinac)>
Date: Tue, 13 Feb 2007 19:49:03 +0100
Jiri Matejka wrote:
>>> nefunguje LIMIT n,-1
> 
>> Od 4.1 plati ze:
>> LIMIT takes one or two numeric arguments, which must both be
>> non-negative integer constants (except when using prepared
>> statements).
>> takze zaporne parametre niesu povolene.
> 
> hmmm, to zase nekdo vymyslel kolo... :-(((
> 
> takze abych nepsal nesystemove LIMIT n,99999999999
> budu muset delat SELECT navic, abych vedel co tam dat jako spravnou
> hodnotu
> to vypada ze uz to snad neprogramujou programatori :-)))
> 
> ale diky za info
> 
> DFly
> 
a dokumentaci k tomu taky něco píšou:

To retrieve all rows from a certain offset up to the end of the result 
set, you can use some large number for the second parameter. This 
statement retrieves all rows from the 96th row to the last:

SELECT * FROM tbl LIMIT 95,18446744073709551615;

	hrazda
Received on 13. 02. 2007, 19:49 CET

This archive was generated by hypermail 2.2.0 : 13. 02. 2007, 19:48 CET