search for: mysqlwritet

Displaying 8 results from an estimated 8 matches for "mysqlwritet".

Did you mean: mysqlwritedb
2010 Mar 04
1
mysqlWriteTable . error in your SQL syntax?
Hi, Can somebody advice on weird mysqlWriteTable bug. > mysqlWriteTable(conn, 'comparison',design2, row.names = F, overwrite=T) Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the...
2003 Nov 25
1
1.8.1. RMySQL Win2K Writing-Table Problem?
Hi, i getting following error and don't know doing something wrong. >mysqlWriteTable(con,"model1",model1,overwrite=T) Error in "[.data.frame"(value, from:to, drop = FALSE) : undefined columns selected In addition: Warning message: drop argument will be ignored in: "[.data.frame"(value, from:to, drop = FALSE) Exactly the same code, database...
2009 Mar 01
0
How to create temporary table in MySQL
...fails Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( x bigint )' at line 2) [1] FALSE Warning message: In mysqlWriteTable(conn, name, value, ...) : could not create table: aborting mysqlWriteTable > dbGetQuery(con, "create temporary table x ( x int);") # workaround NULL > dbWriteTable(con, "x", x, verbose=TRUE,row.names=FALSE, overwrite=T) [1] TRUE > dbGetQuery(con, "select * fr...
2010 Jan 25
1
RMySQL Append data.frame to table
...frame using something like: dbWriteTable(con, "contact", dat, append=TRUE) However, I get this error: Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: Unknown column 'row_names' in 'field list') [1] FALSE Warning message: In mysqlWriteTable(conn, name, value, ...) : could not load data into table Can anyone shed light on this error, or how I might bulk load this data using RMySQL? Cheers, Nathan -- -------------------------------------------------------- Dr. Nathan S. Watson-Haigh OCE Post Doctoral Fellow CSIRO Livestock Indu...
2002 Dec 18
1
A little problem handling logicals in RMySQL under R1.6.1
...dTable(con,"test") > aa x y 1 0 0 2 0 0 > # and this is clearly not what we want... # # as a crude patch I added for (i in 1:length(value)) if (class(value[[i]])=="logical") class(value[[i]])<-"integer" # before i <- match("row.names", ... in mysqlWriteTable # but others have much more talent in writing clean code than I ... # > mysqlWriteTablecrudepatch(con,"test",a,overwrite=TRUE) [1] TRUE # and > aa<-dbReadTable(con,"test") > aa x y 1 1 0 2 0 1 # and this IS what we want. platform i386-pc-mingw32 arch i38...
2003 Nov 24
1
RMySQL valid field names
...p the data frame into a MySQL database everything works fine except the names of these three columns which are slightly different (e.g. 'DateTime_9'). This only occurs with these 3 columns because their names are reserved words of MySQL. The change of names is occurring in the function mysqlWriteTable, namely in the call: ... names(field.types) <- make.db.names(con,names(field.types),allow.keywords=F) ... If I change the parameter allow.keywords into T, everything works fine for me. Given that MySQL allows all characters to be part of field names (section 6.1.2 of MySQL reference manua...
2004 Nov 13
2
Thrashing?
Does R do its own swapping out to disk? I disabled Linux swapping and the system still gets stuck in Purgatory where there's little CPU activity but the disk goes like crazy. That's with R having almost the whole machine to itself and running a memory hungry compute only function. I've seen this behavior with other version numbers but I'm running R 2.0.0 under Fedora Core 3.
2004 Jul 28
3
Another big data size problem
Hi all, I'm trying to read a 1220 * 20000 table in R but I'm having lot of problems. Basically what it happens is that R.bin starts eating all my memory until it gets about 90%. At that point it locks itself in a uninterruptible sleep status (at least that's what top says) where it just sits there barely using the cpu at all but keeping its tons of memory. I've tried with