在Rstudio中使用csv文件创建数据库

library(DBI)
library(RMySQL)  # 或者其他数据库驱动程序，如RPostgreSQL

con <- dbConnect(MySQL(), dbname = "your_database_name", 
                 host = "your_host", port = your_port, 
                 user = "your_username", password = "your_password")

# 读取csv文件
data <- read.csv("path_to_your_csv_file.csv")

# 创建数据表
dbWriteTable(con, "your_table_name", data, overwrite = TRUE)

# 查询数据
query <- "SELECT * FROM your_table_name"
result <- dbGetQuery(con, query)