Mailing List Archive


Back to the month index Back to the list index
Brian Andrews (brian@informate.co.nz)
Sun, 19 Jan 1997 14:10:06 +1300 

Message-Id: <199701190110.OAA05408@ihug.co.nz>
From: "Brian Andrews" <brian@informate.co.nz>
Subject: Re: [mSQL] LIMIT: any better way to solve my problem ?
Date: Sun, 19 Jan 1997 14:10:06 +1300

----------
> From: Giancarlo Russo <interf@interferenza.com>
> To: Brian Andrews <brian@informate.co.nz>
> Subject: Re: [mSQL] LIMIT: any better way to solve my problem ?
> Date: Sunday, 19 January 1997 02:56
>
> > Hi,
> >
> > Try mysql. I believe the latest version does this.
> >
> > brian
>
> Where may I learn more ?
> Thanks

mysql's homepage is at www.tcx.se

>From the latest release it says this
about LIMIT:

>- LIMIT takes now one or two numerical arguments.
  If one argument the argument indicates the maximum number of rows in a
result.
  If two arguments the first arguments says the offset to the first row to
return,
  the second is the maximum number of rows.
  With this it's easy to do a poor mans next page/previous page www
application.
<

cheers

brian

----------------------------------------------------------------------------
----
Brian Andrews
InforMate Technologies Limited
Technology Consultants for Information Automation
Auckland, New Zealand
Ph (+64) 9-489-1001
Fax (+64) 9-489-1002
Mob (+64) 21-OFFICE (633-423)
brian@informate.co.nz
http://www.informate.co.nz
----------------------------------------------------------------------------
----

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!