Hi R users,
I am using RMySQL to connect to a database in MySQL.
I have 3 questions.
1)When I give the following command
dbListTables(con)
I get the output
stack imbalance in .Call, 142 then 143
stack imbalance in <-, 140 then 141
stack imbalance in {, 138 then 139
stack imbalance in standardGeneric, 126 then 127
stack imbalance in class, 121 then 122
stack imbalance in <-, 119 then 120
stack imbalance in {, 117 then 118
stack imbalance in <-, 111 then 112
stack imbalance in {, 109 then 110
[1] "newtable" "ravi"
Could somebody tell me why it shows a stack imbalance?
2)For this command
testcmd1<-fetch(dbSendQuery(con,"select ticker from ravi where
banks>=100"))
> dim(testcmd1)
The output is
[1] 500 1
However when I give the same command directly in MySQL command prompt I
get an output greater than 2000!! (Does fetch have a limitation?)
3) Also is it possible to get output where the NA values are removed?
Thanks in advance for the help
Ravi
[[alternative HTML version deleted]]
______________________________________________
R-help@stat.math.ethz.ch mailing list
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.
