search for: val21

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. > >>>>> > >>>>&...