[linux-leman] mysql

Jiang Wei jiang at ebu.ch
Fri May 2 09:12:17 CEST 2003


> 
> Je souhaite effectuer une requete sur une table, qui me retournerait 
> uniquement un row tout les  n (n=20 par ex) rows. Est-ce possible?

ceci te donnera entre le 1er au 20eme ligne
sql> select * from FOO where Foo_condition LIMIT 1,20

dans un programme, tu peux jouer avec les 2 parametres de LIMIT .

Wei


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
 




More information about the gull mailing list