Hello, I am new to R progaming and have just started using this program since last week. What i want to achieve is 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 returned is > 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>") [1] 1 > odbcClose(ch) No other results. I was expecting to see the table values or some other data. Not that. Maybe I am misunderstanding the whole concept of how R works. If so could someone please help me to clarify what the problem is and perhaps point me to a tutorial or somewhere i can get a information and get a better understanding. Thank you. Your Help will be greatly appreciated. Gayon Clarke [[alternative HTML version deleted]]
______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.