search for: mydfout

Displaying 1 result from an estimated 1 matches for "mydfout".

Did you mean: mdfour
2008 Nov 06
1
RMySql inserts \r when using dbWriteTable
I am using R 2.8 and the latest versions of RMySQL on a Windows XP 64 bit machine. I was wondering if someone could help me figure out how to use dbWriteTable without inserting \r into my table. Consider the following code snippet, which is run after I connect to my database. myDFOut = dbReadTable(conn, "myDF") print(myDFOut) myDFIn = data.frame(x=paste("x", 1:5, sep = ""), y = paste("y", 1:5, sep = "")) dbWriteTable(conn, name= "myDF", value = myDFIn, row.names=F, append =TRUE, eol = "\r\n" ) myDFOut = dbRea...