Guest User

Untitled

a guest
Jun 1st, 2018
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. if (!require(RMySQL)) {
  2. install.packages("RMySQL")
  3. library(DBI)
  4. }
  5.  
  6. host <- "YOURHOST" # 輸入自己的 AWS RDS Enpoint 位址
  7. port <- 3306
  8. dbname <- "YOURDBNAME" # 輸入自己設定的資料庫名稱
  9. user <- "YOURUSERNAME" # 輸入自己設定的使用者名稱
  10. password <- "YOURPASSWORD" # 輸入自己設定的使用者密碼
  11.  
  12. engine <- dbConnect(RMySQL::MySQL(),
  13. host = host,
  14. port = port,
  15. dbname = dbname,
  16. user = user,
  17. password = password
  18. )
  19. boston_celtics <- dbReadTable(engine, name = 'boston_celtics')
  20. View(boston_celtics)
Add Comment
Please, Sign In to add comment