Displaying 1 result from an estimated 1 matches for "past_purchases".
2008 Apr 11
1
SQL INSERT using RMySQL
...rows from a MySQL database using RMySQL, but am having
problems appending rows to an existing table.
What I *want* to do is to append rows to the table, allowing the
database to automatically generate primary key values. I've only
managed to add rows by using
dbWriteTable( con, "past_purchases", newRecords, overwrite=FALSE,
append=TRUE, ...)
And this only appears to properly append rows (as opposed to
overwriting them) IFF
1) the row names for newRecords are new unique primary key values,
2) the argument row.names is TRUE.
If row.names is FALSE, the records will not be appende...