I wrote a data.frame using
dbWriteTable(con, name='db_all', df, overwrite=T, row.names=F)
sucessfully to MySQL using RMySQL. Now I have a second data frame which has a similar structure and try to use
dbWriteTable(con,name='db_all',df1,append=T,row.names=F,overwrite=F)
which gives me
Error in .local(conn, statement, ...) : could not run statement: Unknown column 'zzz' in 'field list'>
In my SQL table I don't have that column name yet and would expect my append=T will add this column in my SQL table, which apparently it does not.