search for: valn1

Displaying 2 results from an estimated 2 matches for "valn1".

Did you mean: val1
2004 May 24
1
RMySQL problem
....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
...t;> 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 ? > >>>>> > >>>>> Th...