Lapointe, Pierre
2007-Jan-16 16:42 UTC
[R] system(mysql... Does not recognize < as passing an attribute (No HTML)
Hi, 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 "<" character is not recognized as an attribute. Thanks, Pierre> version_ platform i386-pc-mingw32 arch i386 os mingw32 system i386, mingw32 status 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}}
Henrique Dallazuanna
2007-Jan-16 17:10 UTC
[R] system(mysql... Does not recognize < as passing an attribute (No HTML)
You can try this:
system(paste('mysql -u hsdlife -p -D life <',
file('c:/teste.txt')),
show.output.on.console = TRUE)
On 16/01/07, Lapointe, Pierre <Pierre.Lapointe@nbf.ca>
wrote:>
> Hi,
>
> 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 "<" character is not recognized as an
attribute.
>
> Thanks,
>
> Pierre
>
> > version
> _
> platform i386-pc-mingw32
> arch i386
> os mingw32
> system i386, mingw32
> status
> 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.
>
--
Henrique Dallazuanna
[[alternative HTML version deleted]]