Guest User

Untitled

a guest
Oct 8th, 2018
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. install.packages('RMySQL',type='source')
  2. library(RMySQL)
  3.  
  4. mysql.host = 'localhost'
  5. mysql.user = 'root'
  6. mysql.password = 'mysql'
  7.  
  8. mydb = dbConnect(MySQL(), user=mysql.user, password=mysql.password, dbname='bloomberg', host=mysql.host)
  9. dbListTables(mydb)
  10.  
  11. > dbListTables(mydb)
  12. [1] "bb_ec_1000" "bb_ec_5000" "bb_ltp_10yr" "bb_ltp_dx" "bb_ltp_ec"
Add Comment
Please, Sign In to add comment