DATA Step, Macro, Functions and more

Select columns from JMP table and upload to MySQL

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Select columns from JMP table and upload to MySQL

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.  


Accepted Solutions
Solution
‎02-12-2018 09:27 AM
Community Manager
Posts: 3,364

Re: Select columns from JMP table and upload to MySQL

Posted in reply to rainier1974

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

View solution in original post


All Replies
Solution
‎02-12-2018 09:27 AM
Community Manager
Posts: 3,364

Re: Select columns from JMP table and upload to MySQL

Posted in reply to rainier1974

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

New Contributor
Posts: 2

Re: Select columns from JMP table and upload to MySQL

Posted in reply to ChrisHemedinger
Oh, sorry, wrong community Smiley Happy Yes, I am using JMP11. Will post it there. Thanks.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 84 views
  • 0 likes
  • 2 in conversation