search for: mysqllocal

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...