[R] export from R to MySQL

[Sean Davis]

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