Check out the R Data Import/Export manual, especially
http://cran.r-project.org/doc/manuals/R-data.html#DBI-_002f-RMySQL
and the RMySQL package.
On Sun, 2005-11-06 at 03:37 +0000, Xiaofan Li wrote: > Dear colleague,
>
> Is it able in R to manipulate data tables as in SQL-based databases?
> Is there any good method in R to locate a special subset of data rows,
which
> satisfy a certain expression of restrictions (e.g. dataTable$peakValue <
> 3.0)? Then if located, is it able for manipulations, for example, to delete
> them from the dataTable?
>
> Cheers,
> Xiaofan
>
> ---
> Xiaofan Li
> Department of Applied Mathematics and Theoretical Physics
> University of Cambridge
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html