如何在R中为RSQLite制作一个良好的可重现的SQL数据库示例

install.packages("RSQLite")

library(RSQLite)

con <- dbConnect(RSQLite::SQLite(), dbname = "example.db")

dbExecute(con, "CREATE TABLE users (id INTEGER, name TEXT, age INTEGER)")
dbExecute(con, "INSERT INTO users VALUES (1, 'John', 25)")
dbExecute(con, "INSERT INTO users VALUES (2, 'Jane', 30)")

result <- dbGetQuery(con, "SELECT * FROM users")
print(result)

dbDisconnect(con)