[R] RMySQL's column limit

Mark Van De Vyver mvyver at gmail.com
Thu Mar 23 09:24:49 CET 2006


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.
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




More information about the R-help mailing list