Message-ID: <BFC2F2BD.1609%sdavis2@mail.nih.gov>
Date: 2005-12-12T14:26:21Z
From: Sean Davis
Subject: export from R to MySQL
In-Reply-To: <8d5a36350512120621g61c9cea5m8342f475db45c432@mail.gmail.com>
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