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,
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:
My apologies,
I'm using R v2.2.1 via the JGR Editor GUI, RMySQL v0.5.7 under windows
XP with latest patches.
MySQL is server version: 4.1.12
I'm pretty sure it's running on a linux box.
The dimension of template is 2000, I know the error kicks in at 3000,
but haven't iterated to find the exact
Mark Van De Vyver wrote:
My apologies,
I'm using R v2.2.1 via the JGR Editor GUI, RMySQL v0.5.7 under windows
XP with latest patches.
MySQL is server version: 4.1.12
I'm pretty sure it's running on a linux box.
It turns out that this may be a MySQL limit:
Thanks for pointing that out. I've run the create table uploaded
with that bug report and it fails for the same reason using MySQL
4.1.12 on linux and 5.0.18-nt
So this is not a limitation of RMySQL.
Regards
Mark
On 3/24/06, Jeffrey Horner [EMAIL PROTECTED] wrote:
Mark Van De Vyver wrote:
My