We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Insert data in to SQL database

Comments

2 comments

  • Avatar
    Stony Smith

    Use the JDBC Store node.

    0
    Comment actions Permalink
  • Avatar
    Paul Rasmussen

    JDBC Store node is great for automatically inserting records into your database.  I also recommend looking at the JDBC Execute node as it gives you greater control of your insert and update statements.  For example, you can pass in SQL field bindings and then use those just as you would in any other SQL tool.  The question marks (?) represent the fields in the same sequence as the SQLQueryFieldBindings property.  For example, an insert statement would look like the following (the dashes denote comments)

    INSERT INTO customers (first_name, last_name, email, id)
    VALUES (?, ?, ?, ?)

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk