[R-sig-DB] [R] Rmysql - dbWritetable

[Spencer Graves]

  Hi, Nilza:


       Did you receive my reply to your earlier post to R-Help, which 
looks to me identical to this 
(https://stat.ethz.ch/pipermail/r-help/2010-October/256012.html)?  I'd 
like to know if you tried what I suggested there.  If you did, what were 
the results?  If not, why not?


       PLEASE do read the posting guide 
"www.R-project.org/posting-guide.html" and provide commented, minimal, 
self-contained, reproducible code.  Your example is not completely self 
contained.  It might help if you include "sessionInfo()".  In my 
previous reply, there are help pages documenting "dbWriteTable" in 10 
different packages.  I've not used "dbWriteTable" very much, but it 
might help to know which of these 10 packages you are using.



       I've found that following the posting guide often helps me find a 
solution to my problem.  If I still can't solve the problem, this often 
helps me pose the question in a way more likely to generate an answer 
that actually helps me solve the problem.


       I'm sorry if this is not any more helpful than my previous reply.
       Spencer Graves


On 10/15/2010 7:39 PM, Nilza BARROS wrote:
>   Dear Rusers,
>
> I am trying to feed my database with data from a file.
>
> But since my file (2010101000.txt) there`s no headers I am facing problem
> because the
> result data.frame is not separated my columns.
>
> How could I set variables names for each columns in *dbWriteTable*? I have
> tried the command below but I don`t know how to fill the *field.type*option.
>
>
> dbWriteTable(con, "b20101010", "./2010101000.txt", overwrite = T, sep =
> "\t",row.names=c("V01", "V02", "V03", "V04", "V05", "V06"," V07","V08",
> "V09", "V10", "V11", "V12", "V13", "V14"),field.type=????)
>
> ===Below what I have been used. I need to know how to set the column names
> to xx (my dataframe).
>
>> drv=dbDriver("MySQL")
>> con<- dbConnect(drv,dbname='buoy',user="xx",password="xxx")
>> dbWriteTable(con, "b20101010", "./2010101000.txt", overwrite = T, sep =
> "\t", head = F)
> [1] TRUE
>> *xx*<- dbGetQuery(con, "SELECT * FROM b20101010  ")
>> xx
> *  V1
> *1 00859 2010 10 10 00 50  -41.51   6.83  -9999   1016  -9999 -9999.0
> -9999.0 -9999.0
> 2 00859 2010 10 09 22 50  -41.51   6.81  -9999   1015  -9999 -9999.0 -9999.0
> -9999.0
> 3 00707 2010 10 09 23 00  -34.04 -37.63  -9999   1025  -9999 -9999.0 -9999.0
> -9999.0
> 4 00005 2010 10 09 23 00  -34.69 -18.89  -9999   1017    207     7.2   297.1
> -9999.0
> 5 00859 2010 10 09 23 50  -41.51   6.81  -9999   1015  -9999 -9999.0 -9999.0
> -9999.0
> 6 00005 2010 10 09 23 00  -34.69 -18.89  -9999   1017    207     7.2   297.1
> -9999.0
> 7 00617 2010 10 09 23 20  -18.43 -23.09  -9999   1023  -9999 -9999.0 -9999.0
> -9999.0
> 8 00707 2010 10 10 00 00  -34.03 -37.62  -9999   1025  -9999 -9999.0 -9999.0
> -9999.0
> 9 00707 2010 10 10 01 00  -34.03 -37.62  -9999   1025  -9999 -9999.0 -9999.0
> -9999.0
> *>  length(xx)
> [1] 1
> *
>
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db


	[[alternative HTML version deleted]]