11.在R语言中使用sql数据

# install.packages("RMySQL", 
#                  repos = "https://mirrors.ustc.edu.cn/CRAN/")
any(grepl("RMySQL",installed.packages()))
library(RMySQL)

# dbname 为数据库名，这边的参数请根据自己实际情况填写
mysqlconnection = dbConnect(MySQL(),
                            user = 'root', 
                            password = '126428', 
                            dbname = 'sql_tutorial',
                            host = 'localhost')

# 查看数据
dbListTables(mysqlconnection)
# 查询 sites 表，增删改查操作可以通过第二个参数的 SQL 语句来实现
result = dbSendQuery(mysqlconnection, "SELECT * FROM `metabolomic v1.0.10`;")

# # 获取前面两行数据
# data.frame = fetch(result, n = 2)
# print(data.frame)

metabolomic = fetch(result)
print(metabolomic)
ggplot2::ggplot(metabolomic,aes(Name,`Molecular Weight`))+
  geom_point()+coord_flip()

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26