Categories
data science

Connecting to data base using RMySQL package – R

### Note to self ###
# You obviously have MySQL up and running, and you've
# already loaded all your tables and stuff.  

library(RMySQL)

mydbCon<-dbConnect(MySQL(),dbname="nameOfDataBase",user='me')

# Then for a dbq

dbGetQuery(mydbCon,'SELECT `something` FROM `mydb` ')


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s