1)txt导入R 参考语句:(需要保证txt用utf-8保存)
dt<-read.table("C:\\Users\\user\\Desktop\\dt.txt",encoding = "UTF-8")
2)mysql导入R参考语句:
library(RODBC)
channel<-odbcConnect("testmysql", uid="root", pwd="hello123",DBMSencoding = "UTF-8")
sqlTables(channel)
querydt<- sqlQuery( channel,'select * from tmp_disease_tb_b limit 100');
备注:其中odbcConnect里面的testmysql是需要在odbc数据源管理里面自己配的
参考图