On 12/12/05 9:21 AM, "bogdan romocea" <[EMAIL PROTECTED]> 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
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
