Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Can you recommend some trick to create MySQL table to insert data from input?

  1. #1
    Join Date
    Jun 2016
    Posts
    181

    Default Can you recommend some trick to create MySQL table to insert data from input?

    Hello there,

    Sometimes it takes time to manually create MySQL table to insert data from some input (if lot of fields).
    Maybe there is some trick to receive ready 'table create' code?
    Regards,

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    When push button "SQL" in table output, Update or Insert / Update step you get create statement when table doesn't exist

  3. #3
    Join Date
    Jun 2016
    Posts
    181

    Default

    Quote Originally Posted by johanhammink View Post
    When push button "SQL" in table output, Update or Insert / Update step you get create statement when table doesn't exist
    This is what I needed.

    Have a great day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.