我有一个数据库表- db.tbl。我已经在 CentOS 7.0 版本上安装了 R。我已经安装了以下软件包
dbname='db'
table='table'
username='username'
password='userpass'
hostname='1.1.1.111'
port=0000
我编写了以下代码来连接mysql
require(rmysql)
conn <- dbConnect(MySQL(), username, userpass, hostname1, port=0000)
我收到此错误
Error in MySQL() : could not find function "MySQL"
我试过:
conn<-dbConnect("MySQL", username, userpass, hostname1, port=0000)
Error in (function (classes, fdef, mtable) :
unable to find an inherited method for function ‘dbConnect’ for signature
‘"character"
我认为您缺少数据库名称
library(RMySQL)
conn <- dbConnect(MySQL(), user='username',
password='password',
dbname='database_name')
连接后,您可以向Mysql发送查询,例如:
dbWriteTable(conn, name='mtcars', value=mtcars.df, overwrite = T)
如果不起作用,请尝试重新安装 RMySQL 软件包。希望它对:)有所帮助