Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- install.packages('RMySQL',type='source')
- library(RMySQL)
- mysql.host = 'localhost'
- mysql.user = 'root'
- mysql.password = 'mysql'
- mydb = dbConnect(MySQL(), user=mysql.user, password=mysql.password, dbname='bloomberg', host=mysql.host)
- dbListTables(mydb)
- > dbListTables(mydb)
- [1] "bb_ec_1000" "bb_ec_5000" "bb_ltp_10yr" "bb_ltp_dx" "bb_ltp_ec"
Add Comment
Please, Sign In to add comment