Hi, Scenario is: I have a JMP table :JMPCol1,JMPCol2,JMPCol3,JMPCol4,JMPCol5,JMPCol6 and MySQL database: Field1,Field2,Field3,Field4,Field5,Field6,Field7,Field8. I want to do insert all rows : Insert INTO DB.Table (JMPCol1,JMPCol3,JMPCol7) values (Field2,Field4,Field1) . I have not seen any examples online on how to do it. One suggestion was to save to csv then do a bulk insert, but if there is a more direct way of doing it .... Thanks.
... View more