[R] help with RMySQL
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.
[R] Unable to connect to PostgreSQL
Hi R users, I am a beginner trying to connect to PostgreSQL using R When I give the following command drv-dbDriver(PostgreSQL) I am getting the following errorError in do.call(as.character(drvName), list(...)) : could not find function PostgreSQL I have installed PostgreSQL 8.1 in my system. I am currently using R 2.3.1. Any help would be welcome Thanks 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.
[R] Unable to load RMySQL
Hi R users, I am unable to load RMySQL. The zip file is not available which I guess is needed to load this pakage. I also tried extracting the package from RMySQL_0.5-11.tar.gz and then pasted the package in the directory where R is loaded for which I am getting the following error message Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed 2.0.0? Any help would be welcome Thank you, 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.
