topic Select columns from JMP table and upload to MySQL in SAS Programming

Select columns from JMP table and upload to MySQL

rainier1974 — Mon, 12 Feb 2018 13:22:58 GMT

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.

Re: Select columns from JMP table and upload to MySQL

ChrisHemedinger — Mon, 12 Feb 2018 13:24:36 GMT

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

Re: Select columns from JMP table and upload to MySQL

rainier1974 — Mon, 12 Feb 2018 14:27:18 GMT

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