如何在Windows中使用RMySQL? [英] How to use RMySQL in Windows?

问题描述

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

I tried to use RMySQL package but i get this error doing:

install.packages('RMySQL')

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

如何在R中使用MySQL?

What can I do to use MySQL with R?

谢谢！

推荐答案

没有Windows二进制文件可用于程序包RMySQL.这意味着您将必须从源代码安装此软件包并自行构建.

There is not a windows binary available for the package RMySQL. This means you will have to install this package from source and build it yourself.

在 CRAN RMySql 页面上，您会发现没有可用的二进制文件，其中包含指向适用于Windows的R-2.14.x的预编译二进制程序包

At the CRAN RMySql page you will notice there is no binary available, with a link to 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安装和管理，安装RTools，然后使用:

So, read the manuals, in particular R Installation and Administration, install RTools, and then use:

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

这篇关于如何在Windows中使用RMySQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！