[R] R Mysql Not reading all table names

MacQueen, Don macqueen1 at llnl.gov
Mon Oct 3 21:33:38 CEST 2016

You could try
and do the subsetting afterwards.

Also try
instead of dbSendQuery()

(There's no obvious reason that I can see to use dbSendQuery() followed by
fetch. It would be interesting if the two ways return different lists of

Don MacQueen

Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550

On 10/3/16, 9:13 AM, "R-help on behalf of Vivek Singh"
<r-help-bounces at r-project.org on behalf of vivek4 at mail.usf.edu> wrote:

>Hi All:
>I am using R with MySQL, following is my code:
>con <- dbConnect(MySQL(), user="user", password="password", dbname="db",
>rs1 <- dbSendQuery(con, "show tables like \"%padded\"")
>all_tables3<- fetch(rs1, n=-1)
>There are 25 tables in the database when I execute the above query on the
>MySQL prompt. However, the above R code giving me only 9 tables. It seems
>there is some cache from which R is getting 9 tables instead of 25 tables.
>Please help.
>Vivek Kumar Singh
>PhD student,
>Information Systems Decision Sciences,
>MUMA College of Business,
>Phone- (813) 5809131
>Web: http://vivek4.myweb.usf.edu/
>	[[alternative HTML version deleted]]
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>PLEASE do read the posting guide
>and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list