服务热线
178 0020 3020
library(DBI)
library(RMySQL)
任务一:完全按照R2-14 Lucy大美女的方法安装测试,非常感谢!
任务二/三
library(RISmed)
con <- dbConnect(MySQL(),dbname="practice",username="root",password="")
cell2017<-EUtilsSummary("cell[TA] AND 2017[DP]")
data<-QueryId(cell2017)
pmid<- as.numeric(data)
mylist<-data.frame(id=1:562,pmid=pmid,title=ArticleTitle(records),abstract=AbstractText(records))
dbWriteTable(con,"article",mylist,append=T,row.names=F)
附件