Re: [R] sqlsave and mysql database with autoincremental column

2011-02-03 Thread PtitBleu
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 c

[R] sqlsave and mysql database with autoincremental column

2011-02-01 Thread PtitBleu
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 th