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...