0

I'm passing a simple data.frame object to a MySql connection.

The problem is that dbWriteTable() call return this error message:

Error in .local(conn, statement, ...) : 
  could not run statement: Unknown column 'row_names' in 'field list'

I tried:

row.names = FALSE

as a parameter to my dbWriteTable()

and 

rownames(df) <- NULL

neither of these worked.

divibisan
  • 11,659
  • 11
  • 40
  • 58
Mehdi Zare
  • 1,221
  • 1
  • 16
  • 32
  • 1
    Please provide the actual code that's generating the error, the error alone is not enough for us to help. – Mako212 Sep 14 '18 at 21:02
  • @Mako212 Code added. – Mehdi Zare Sep 14 '18 at 21:17
  • @MehdiZare They mean that you should show the **actual** code you used, including the `dbWriteTable()` call and the data.frame you wanted to pass. Use `dput` to paste in the data.frame – divibisan Sep 14 '18 at 21:23
  • Please post a full code block not separate line snippets. I do not see `dbWriteTable` called with data frame object. – Parfait Sep 14 '18 at 22:22

0 Answers0