[R] system(mysql... Does not recognize < as passing an attribute

From: Lapointe, Pierre <Pierre.Lapointe_at_nbf.ca>
Date: Tue 16 Jan 2007 - 16:37:07 GMT


This is my command line request: mysql -u root -ppassword -D quant <c:/cline.txt
This line works from the command line in windows.

In R, when I try to use the system function, it does not work,

> system(paste('mysql -u root -ppassword -D quant
<c:/cline.txt'),show.output.on.console = TRUE) ERROR 1102 (42000): Incorrect database name '<c:/cline.txt'

It seems that the "<" caracter is not recognized as an attribute.



> version

platform       i386-pc-mingw32             
arch           i386                        
os             mingw32                     
system         i386, mingw32               
major          2                           
minor          4.1                         
year           2006                        
month          12                          
day            18                          
svn rev        40228                       
language       R                           
version.string R version 2.4.1 (2006-12-18)

AVIS DE NON-RESPONSABILITE: Ce document transmis par courrie...{{dropped}}

R-help@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 and provide commented, minimal, self-contained, reproducible code. Received on Wed Jan 17 03:47:38 2007

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 16 Jan 2007 - 17:30:27 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.