search for: assignt

Is it true that append=T does not work in assignTable() in RMySQL ? More specifically: I cannot append a data.frame to an existing table in a MySQL database, although I can use the same data.frame to create a new table. Even more specifically: > assignTable(con,"employee",dita,append=T) Error in execStatement.MySQLConnection(con, s...

Dear laurent, > But there are lots of commands I found in R docs which are "not found", > such as getTable. Deprecated (I successfully used dbListTables) or do I > simply miss a package ? >From RMySQL\NEWS: * added (almost) trivial convenience RS-DBI functions getTable(), assignTable(), existsTable(), and removeTable(). They all mimic the corresponding R/S get(), assign(), exists(), and remove(), and they all work with a connection object and an sql table name (NOT generic SQL queries); assignTable() assigns a data.frame object (or coerceable) to the database....

...MySQL for (i in 1:length(p0fichiers)) { donnees<-read.table(p0fichiers[i], quote="\"", sep=";", dec=",", skip=18) jourheure<-paste(donnees$V1, donnees$V2, sep=" ") donnees[1]<-jourheure donnees<-donnees[,-2] # assignTable(con, "Datatable", donnees, append=TRUE) - Ne marche pas dbWriteTable(con, "Datatable", donnees, append=TRUE) rm(donnees, jourheure) } # Idem avec les fichiers d'extension .Px en chargant toutes les lignes (skip=0) # Amelioration possible : creer une fon...

...for each company and put it in another dataset/table. The procedure can be done easily done with a loop statement, but i need to retrieve each individual coefficient, t-stat, R^2, etc... I know that, using the $coefficients command will return the vector of coeffcients but I'm having trouble to assignt it to the correct row in the final dataset. Furthermore, I can't find any way of retrieving the R^2 and t-stats... Thanks for any help, Pablo.

Hi, I'm experimenting with using (R)SQLite to do data management. Here are two little problems that I've encountered: 1. The presence of ',' in string values causes trouble since ',' is also the delimiter used in the SQL statement. 2. A newline '\n' line attached to the last string value of each row. Some examples: > library (RSQLite) Loading required

Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30