[R] Numerical print format and loading with RMySQL

[dhinds at sonic.net]

Nathan Johnson <njohnson at ebi.ac.uk> wrote:

> I constructed a data frame with columns corresponding to the table  
> fields, and tried with and without a null column for the auto- 
> increment internal id column.  I also tried renaming all the column  
> names to match those of the table fields.  All of my attempts  
> resulted in a long wait and "TRUE" being printed to the terminal,  
> which I though was quite promising, however, on inspection of the DB,  
> I found nothing had been written.

Is it possible you needed a call to dbCommit()?

-- Dave