search for: past_purchases

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...