Re: [R] Question: RMySQL bulk load/update one column, dbWriteTable()?

2007-06-06 Thread Waverley
Thanks Chris. I am trying almost the same solution while I have failed the dbWriteTable. The problem of using update is that it is way TOO slow when the row size is ~20. That is why I hope I can still get dbWriteTable way to add one column. dbWriteTable is very efficient and fast. The probl

Re: [R] Question: RMySQL bulk load/update one column, dbWriteTable()?

2007-06-06 Thread Chris Stubben
> I have a question reading using RMySQL trying to load one R vector into a > table column. To be more specifically, the table is there populated. Now I > add a new column and want to populate this. > Okay, this is more of an SQL question now, but you could just use dbWriteTable and then do a

[R] Question: RMySQL bulk load/update one column, dbWriteTable()?

2007-06-06 Thread Waverley
Hi, I have a question reading using RMySQL trying to load one R vector into a table column. To be more specifically, the table is there populated. Now I add a new column and want to populate this. Can some colleagues on this list teach me how to do this? I know how to write one R object/table