R help - Feb 2011 - sqlsave and mysql database with autoincremental column

Hello,

I'm trying to modify my r-script to use RODBC instead of DBI/RMySQL (no more
ready-to-use package for windows).

I would like to copy a data.frame of 44 columns to a table of 45 columns
(the 45th is an autoincremental column).

With the following commands, 

colnames(df)<- a vector with the names of the 44 columns
ch<-odbcDriverConnect(connection="SERVER=localhost;DRIVER=MySQL ODBC 5.1
Driver;DATABASE=my_db;UID=usercount;PWD=my_pwd;case=tolower")
sqlSave(ch,my_df, "my_table", append = TRUE, rownames = FALSE,
fast=FALSE)
odbcClose(ch)

I got the following message (in french, sorry): 
Erreur dans dimnames(x) <- dn :  la longueur de 'dimnames' [2]
n'est pas
?gale ? l'?tendue du tableau
It means something like: the length of 'dimnames' [2] is not equal to
the
array extent

If I do the same with a table with only 44 columns, without the
autoincremental column, it works ... but I need this last column.

Could you please help me to modify my commands so that I can copy 44-columns
data.frame to the 45-columns MySQL table ?

Thanks in advance,
Ptit Bleu.





-- 
View this message in context:
http://r.789695.n4.nabble.com/sqlsave-and-mysql-database-with-autoincremental-column-tp3251425p3251425.html
Sent from the R help mailing list archive at Nabble.com.

I found a solution (certainly not the best one but it works).
I add a 45th column full of 0 to the 44-columns data.frame.
When I copy the data.frame to the database with sqlsave, the last column of
the table is not full of 0, but it autoincrements.

Another small question: what is the command to copy, for example, the 5th
and the 7th column to the table ?

Have a nice end of day,
Ptit Bleu.
-- 
View this message in context:
http://r.789695.n4.nabble.com/sqlsave-and-mysql-database-with-autoincremental-column-tp3251425p3258351.html
Sent from the R help mailing list archive at Nabble.com.