Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- library(RMySQL)
- library(dbConnect)
- mydb = dbConnect(MySQL(), user='user',
- password='password', dbname='blank_copy',
- host='ip address', port = port_number)
- dbListTables(mydb)
- dbListFields(mydb, 'SELECT * FROM table_name')
- dbReadTable("table_name")
Add Comment
Please, Sign In to add comment