02-12-2018 08:22 AM
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 ....
Need further help from the community? Please ask a new question.