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; hrazdaReceived on 13. 02. 2007, 19:49 CET
This archive was generated by hypermail 2.2.0 : 13. 02. 2007, 19:48 CET