R語言串連Mysql資料庫

標籤：r語言 stock 股票 mysql

install.packages("DBI")

install.packages("RMySQL")

library(DBI)

library(RMySQL)

con <- dbConnect(MySQL(),host="XXXXX",dbname="stocku",user="root",password="XXXX")

dbListTables(con)

dbReadTable(con, "stockbase")

dbDisconnect(con)

300G
的資料慢慢分析吧

////////////////////

[7057] "002630_W"    "002630_tick" "002631_15"   [7060] "002631_30"   "002631_5"    "002631_60"   [7063] "002631_D"    "002631_M"    "002631_W"    [7066] "002631_tick" "002632_15"   "002632_30"   [7069] "002632_5"    "002632_60"   "002632_D"    [7072] "002632_M"    "002632_W"    "002632_tick" [7075] "002633_15"   "002633_30"   "002633_5"    [7078] "002633_60"   "002633_D"    "002633_M"    [7081] "002633_W"    "002633_tick" "002635_15"   [7084] "002635_30"   "002635_5"    "002635_60"   [7087] "002635_D"    "002635_M"    "002635_W"    [7090] "002635_tick" "002636_15"   "002636_30"   [7093] "002636_5"    "002636_60"   "002636_D"    [7096] "002636_M"    "002636_W"    "002636_tick" [7099] "002637_15"   "002637_30"   "002637_5"    [7102] "002637_60"   "002637_D"    "002637_M"    [7105] "002637_W"    "002637_tick" "002638_15"   [7108] "002638_30"   "002638_5"    "002638_60"   [7111] "002638_D"    "002638_M"    "002638_W"    [7114] "002638_tick" "002639_15"   "002639_30"   [7117] "002639_5"    "002639_60"   "002639_D"    [7120] "002639_M"    "002639_W"    "002639_tick" [7123] "002640_15"   "002640_30"   "002640_5"    [7126] "002640_60"   "002640_D"    "002640_M"       reservedPerShare    esp   bvps      pb timeToMarket1                0.19  0.361   7.46    3.95     201609282                0.46  0.222   4.41    4.41     201609283                0.73  0.371   5.51    4.22     201609284                0.15  0.115   2.97    4.65     201609195                0.04  0.263   2.54    7.52     200611286                0.41  0.014   2.16   11.18     201408017                0.22  0.069   2.13   10.50     201609148                2.52  0.047   3.88    2.12     201005209                0.20  0.256   4.61    1.86     2016092310               0.67  0.211   4.12    9.13     20160913

//////////////////////////////////////

本文出自 “坐坐吧” 部落格，請務必保留此出處http://lwglucky.blog.51cto.com/1228348/1858657

R語言串連Mysql資料庫