Try this >drv <- dbDriver("MySQL") >con(drv, etc parameters...) > dbGetQuery(con, "select * from tableyoulike limit N_integer_first_records")
Hope it helps Caveman On Fri, Dec 25, 2009 at 12:10 AM, Peng Yu <pengyu...@gmail.com> wrote: > I only want to load a limited number of rows by dbReadTable(). I don't > see an option in the help. Is there an option to do so? > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- OpenSource Software Consultant CENFOSS (www.cenfoss.co.mz) SP Tech (www.sptech.co.mz) email: orvaq...@cenfoss.co.mz cell: +258828810980 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.