mysql - 如何在 Windows 中使用 RMySQL？

Question

我尝试使用 RMySQL 包，但在执行以下操作时出现此错误:

install.packages('RMySQL')

Warning in install.packages :
  package ‘RMySQL’ is not available (for R version 2.14.2)

如何将 MySQL 与 R 结合使用？

谢谢!

Answer 1

RMySQL 包没有可用的 Windows 二进制文件。这意味着您必须从源代码安装此包并自行构建。

在 CRAN RMySql页面你会注意到没有可用的二进制文件，链接到 Pre-compiled binary packages for R-2.14.x for Windows

从这个页面:

Packages related to many database system must be linked to the exact 
version of the database system the user has installed, hence it does 
not make sense to provide binaries for packages
    RMySQL, ROracle, ROracleUI,
although it is possible to install such packages from sources by
    install.packages('packagename', type='source')
after reading the manual 'R Installation and Administration'.

因此，请阅读手册，尤其是 R Installation and Administration ，安装 RTools，然后使用:

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