Re: [R] R Mysql Not reading all table names

You could try dbListTables() and do the subsetting afterwards. Also try dbGetQuery() 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 tables.) -- Don MacQueen Lawrenc

Re: [R] R Mysql Not reading all table names

On Mon, Oct 3, 2016 at 11:13 AM, Vivek Singh wrote: > 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_table

[R] R Mysql Not reading all table names

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 exec