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