[R] using R how to read a one column alone from a database table from MySQL

[sankar82]

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.