using R how to read a one column alone from a database table from MySQL
hello dieter, sorry for the late reply... yes my homework needs to be done in R and thats y i have these questions posted in this forum...hope u reply me the solutions and also thank you for spending ur precious time in my problem... BR sankar.
Dieter Menne wrote:
sankar82 <sankar.arughadhoss <at> tkk.fi> writes:
i have a created a database table in MYSQL consisting of 11 columns. throught RMYSQL i managed to read the entire table in R. but i have few qureries which i need solutions...here they are: 1. Using R how to read a one column alone from a database table from MYSQL. 2. Using R how to print on screen those column value. 3. Using R how to print one particular row (in this case row is X)value alone. 4. Using R how to read all the column (11) and print (X) value alone on screen. 5. Using R with logic print those (X) value which is/between say 20 to 30 degrees.
Have you tried the examples in Rmysql-package? For 5., you could use something like: dbSendQuery(con, "select * from WL where width\_nm between 0.5 and 1") Ok, here we let SQL do the job, and you homework want it to be done in R. Dieter
______________________________________________ R-help at 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.
View this message in context: http://www.nabble.com/using-R-how-to-read-a-one-column-alone-from-a-database-table-from-MySQL-tp21478288p21543180.html Sent from the R help mailing list archive at Nabble.com.