R语言数据库操作（不定时更新）

Install.packages(“RODBC”)

library(RODBC)

odbcDataSources()

channel <- odbcConnect("localserver")

channel <- odbcConnect("localserver ", uid = "user ", pwd = "**** ")

Table_a<-sqlFetch(channel,"table_a")

sqlTables(channel)

sqlQuery(channel,"select * from Table_a")

sqlDrop(channel,"Table_a")

sqlSave(channel,new_table)

odbcClose(channel)

Install.packages(“RMySQL”)

library(RMySQL)

conn<-dbConnect(MySQL(),dbname="database",username="***",password="****",
host="localhost", port=3306)

summary(conn)

dbListTables(conn)

dbReadTable(conn, "table_name")

dbRemoveTable(conn,"table_name")

dbGetQuery(con, "SELECT * FROM table_a limit 3")

res <- dbSendQuery(con, "SELECT *FROM table_a ")
data <- dbFetch(res, n=2)

dbWriteTable(conn,"table_a",b(要写入的数据),append = TRUE)

dbDisconnect(conn)

R语言数据库操作（不定时更新） | DataLearnerAI

r语言数据库操作汇总（不定时更新）