[R] RMySQL's column limit

[David James]

Hi,

Mark Van De Vyver wrote:
> Dear R-users,
> First, thank you to the developers for the very useful R-library RMySQL.
> 
> While using this library a recieved an error message:
> 
> RS-DBI driver: (could not run statement: Too many columns)
> 
> The statement that generated the error was:
> 
> dbWriteTable(dbcon, "simdataseries", template, overwrite = TRUE,
> row.names = FALSE )
> 
> I am assuming this is a RMySQL rather than MySQL limit.

We need more information, e.g., what's dim(template), what version
of MySQL you're using, etc.

> If that is the case I was wondering just what this limit is and if it
> is possible to raise it?
> 
> Thanks again for all the hard work.
> 
> Sincerely
> Mark
> 
> --
> Mark Van De Vyver, PhD
> --------------------------------------------------
> My research is available from my SSRN Author page:
> http://ssrn.com/author=36577
> --------------------------------------------------
> Finance Discipline
> School of Business
> The University of Sydney
> Sydney NSW 2006
> Australia
> 
> Telephone: +61 2 9351-6452
> Fax: +61 2 9351-6461
> 
> 
> --
> Mark Van De Vyver, PhD
> --------------------------------------------------
> My research is available from my SSRN Author page:
> http://ssrn.com/author=36577
> --------------------------------------------------
> Finance Discipline
> School of Business
> The University of Sydney
> Sydney NSW 2006
> Australia
> 
> Telephone: +61 2 9351-6452
> Fax: +61 2 9351-6461
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

-- 
David