[R] sqlsave and mysql database with autoincremental column

PtitBleu ptit_bleu at yahoo.fr
Thu Feb 3 16:50:09 CET 2011


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.



More information about the R-help mailing list