Displaying 2 results from an estimated 2 matches for "val21".
Did you mean:
val2
2004 May 24
1
RMySQL problem
...nce to insert a complete data.frame into a table. I've tryied
to use "paste" to build the sql string but It works "by column" and I
need it "by row" ...
The sql systax should be something like:
INSERT INTO TABLEA(COL1, COL2, COL3) VALUES
(VAL11, VAL12, VAL13),
(VAL21, VAL22, VAL23),
...
(VALN1, VALN2, VALN3);
and I have a data.frame with 3 columns corresponding to that table
columns.
How can I do this ?
Thanks
EJ
2004 May 25
0
RMySQL problem - SOLVED
...; need it "by row" ...
> >>>>>
> >>>>> The sql systax should be something like:
> >>>>>
> >>>>> INSERT INTO TABLEA(COL1, COL2, COL3) VALUES
> >>>>> (VAL11, VAL12, VAL13),
> >>>>> (VAL21, VAL22, VAL23),
> >>>>> ...
> >>>>> (VALN1, VALN2, VALN3);
> >>>>>
> >>>>> and I have a data.frame with 3 columns corresponding to that table
> >>>>> columns.
> >>>>>
> >>>>&...