Peng Yu
2009-Dec-24 22:10 UTC
[R] How to dbReadTable() only a limited number of rows? (RMySQL)
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?
Orvalho Augusto
2009-Dec-25 14:10 UTC
[R] How to dbReadTable() only a limited number of rows? (RMySQL)
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.ut at 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 at 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: orvaquim at cenfoss.co.mz cell: +258828810980