[R] R Mysql Not reading all table names

[Vivek Singh]

Hi All:

I am using R with MySQL, following is my code:

library(RMySQL)
con <- dbConnect(MySQL(), user="user", password="password", dbname="db",
host="localhost")
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.

Regards,

Vivek Kumar Singh

PhD student,
Information Systems Decision Sciences,
MUMA College of Business,
USF
Phone- (813) 5809131
Web: http://vivek4.myweb.usf.edu/

	[[alternative HTML version deleted]]