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]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
