export from R to MySQL
On 12/12/05 9:21 AM, "bogdan romocea" <br44114 at gmail.com> wrote:
Sean Davis wrote: but you will have to create the table by hand
There's no need for manual steps. To take advantage of MySQL's
extremely fast 'load data infile' you could dump the data in CSV
format, write a script for mysql (the command line tool), for example
q <- function(table,infile)
{
query <- paste("
create table ",table," (col1 float, col2 float);
This is creating the table by hand, as opposed to using dbWriteTable. If your data.frame contains 67 columns, using dbWriteTable saves quite a bit of typing.... Sean