Displaying 1 result from an estimated 1 matches for "mysqllocal".
Did you mean:
mysql_local
2014 Jun 30
1
Getting data from Table in RStudio
...to use R to determine patterns in sales/ customer complaint etc. information located in a mysql database. I am not sure how to approach this or which technique i should use to do so. However, i had proceeded to add a dataset to RStudio using the following code:
library(RODBC)
dsn.name <- "MySQLlocal"
user.name <- "orange"
pwd <- ""
ch <- odbcConnect(dsn=dsn.name,uid=user.name,pwd = pwd)
res <- sqlFetch(ch, "<my_table_name>")
odbcQuery(ch, "Select * from <my_table_name>")
odbcClose(ch)
When the code is run all that is retur...