R 操作数据库——搭建数据分析平台

> install.packages("Rserve")

--- 在此連線階段时请选用CRAN的鏡子 ---

试开URL’https://mirrors.tongji.edu.cn/CRAN/bin/windows/contrib/3.4/Rserve_1.7-3.zip'

Content type 'application/zip' length 632080 bytes (617 KB)

downloaded 617 KB

程序包‘Rserve’打开成功，MD5和检查也通过

下载的二进制程序包在

C:\Users\AppData\Local\Temp\RtmpYXwInP\downloaded_packages里

> library(Rserve);

> Rserve();

Starting Rserve...

"D:\environment\R-3.4.4\library\Rserve\libs\x64\Rserve.exe"

> library(RODBC);

> channel <-odbcConnect("mydata",uid = "root",pwd="123");

> sqlTables(channel);

TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS

1 airdata airinfo TABLE

> data<-sqlFetch(channel,"airinfo")

>