[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [PROGRAMMERING] MySQL begrænset SELECT



On Thu, 12 Aug 2004 23:15:44 +0200, Peter Maersk-Moller wrote:


> Antag, at jeg har en db-table med 100, 1000 eller 1000000 rækker. Når
> jeg nu søger, ønsker jeg f.eks. kun at få vist N rækker af gangen,
> da jeg alligevel ikke praktisk kan vise en million linjer på en
> webside.
> 
> kan man gøre noget i stil med
> 
>    SELECT * FROM db-table START=50 END=99;
> 
> som så skulle returnere række 50 til række 99 ?
> 
SQL-kommandoen hedder select tuple(s) from table where condition [LIMIT
{[offset,] row_count | row_count OFFSET offset}]
> Det hedder nok ikke START og END, man kan man opnå det ønskede på en
> eller anden måde og betyder det noget for dan samlede load ?
http://dev.mysql.com/doc/mysql/en/LIMIT_optimization.html

-- 
Hilsen/Regards
Michael Rasmussen

Get my public GnuPG keys:
mir <at> datanom <dot> net
http://search.keyserver.net:11371/pks/lookup?op=get&search=0xE501F51C
mir <at> miras <dot> org
http://search.keyserver.net:11371/pks/lookup?op=get&search=0xE3E80917
--------------------------------------------------------------
Say what you mean, simply and directly.
            - The Elements of Programming Style (Kernighan & Plaugher)




 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2005-08-10, 22:44 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *