1 min read

【技术·R】🗄️ RMarkdown中SQL使用:查询与整合

参考bookdown

library(DBI)
con <- dbConnect(RSQLite::SQLite(), ":memory:")
dbWriteTable(con, "mtcars", mtcars)
library(glue)
tbl <- "mtcars"
SELECT * FROM `mtcars` where gear IN (3, 4)