[R] R Mysql Not reading all table names

Vivek Singh vivek4 at mail.usf.edu
Mon Oct 3 18:13:05 CEST 2016

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]]

More information about the R-help mailing list