如何在Windows 7上安装RMySQL包

Question

我想在我的电脑上安装RMySQL包在Windows 7上运行。在软件包网站http://cran.r-project.org/web/packages/RMySQL/index.html上，似乎不存在Windows软件包版本…我试着去理解ReadMe，但我做不到。

有人能告诉我如何正确安装这个包吗?

我尝试了以下代码

install.packages('RMySQL', type='source')

，我得到以下消息:

Warning in install.packages :
  package ‘RMySQL’ is not available (for R version 3.0.0)
Installing package into ‘C:/Users/XXXXX/Documents/R/win-library/3.0’
(as ‘lib’ is unspecified)
trying URL 'http://cran.rstudio.com/src/contrib/RMySQL_0.9-3.tar.gz'
Content type 'application/x-gzip' length 165363 bytes (161 Kb)
opened URL
downloaded 161 Kb
* installing *source* package 'RMySQL' ...
** package 'RMySQL' correctement décompressé et sommes MD5 vérifiées
ERROR: configuration failed for package 'RMySQL'
* removing 'C:/Users/XXXXX/Documents/R/win-library/3.0/RMySQL'
Warning in install.packages :
  running command '"C:/PROGRA~1/R/R-30~1.0/bin/x64/R" CMD INSTALL -l "C:UsersXXXXXDocumentsRwin-library3.0" C:UsersXXXXXAppDataLocalTempRtmpo9RLF3/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1
Warning in install.packages :
  installation of package ‘RMySQL’ had non-zero exit status
The downloaded source packages are in
    ‘C:UsersXXXXXAppDataLocalTempRtmpo9RLF3downloaded_packages’

在RStudio的Packages窗口中什么也没有出现…谢谢你的帮助。

Answer 1

您可能想看看RODBC包作为一个解决方案。

Answer 2

自定义文件:

软件包涉及到的很多数据库系统都必须链接到精确的用户已安装的数据库系统的版本，因此显示为RMySQL, ROracle，ROracleUI, TSMySQL, dbConnect，虽然可以安装这些通过install.packages('packagename'，type='source')政府"。