Select columns from JMP table and upload to MySQL

[rainier1974]

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.  

[ChrisHemedinger · Accepted solution]

Are you using SAS or JMP for this?  If JMP, you probably want to post this question to our friends at community.jmp.com.

[rainier1974]

Oh, sorry, wrong community 🙂 Yes, I am using JMP11. Will post it there. Thanks.