phpbar.de logo

Mailinglisten-Archive

Re: mySQL + PHP: "Wievielte Zeile eines Selects ist mein Ergebnis"
Archiv Mailingliste mysql-de

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: mySQL + PHP: "Wievielte Zeile eines Selects ist mein Ergebnis"



Hoi Patrick,

> Diese Form von LIMIT ist ununterstützt!


Ich zitiere aus dem Manual zu 2.23.10alpha:
--- Snippel ---
The LIMIT clause can be used to constrain the number of rows returned by
the SELECT statement. LIMIT takes one or two numeric arguments. If two
arguments are given, the first specifies the offset of the first row to
return, the second specifies the maximum number of rows to return. The
offset of the initial row is 0 (not 1). 
mysql> select * from table LIMIT 5,10;  # Retrieve rows 6-15

If one argument is given, it indicates the maximum number of rows to
return. 
mysql> select * from table LIMIT 5;     # Retrieve first 5 rows

In other words, LIMIT n is equivalent to LIMIT 0,n. 
--- Snappel ---

Gruß Jan

---
*** Weitere Infos zur Mailingliste und MySQL unter www.4t2.com/mysql 


Home | Main Index | Thread Index

php::bar PHP Wiki   -   Listenarchive