Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

SQL Data Source Insert and Update rows


  • Hi,

    if I want to insert new values or update values in a mySQL table it works for me with single values (=?), set via Meta Data Source point:

    INSERT INTO table_xz (
    IDNr, ValveNr, LineNr, StartTime) 
    VALUES (?,'KS0717','B',NOW())
    

    But if I want insert more then one ?:

    INSERT INTO table_xz (
    IDNr, StartSum, StartTemp, ValveNr, LineNr, StartTime) 
    VALUES (?,?,?,'KS0717','B',NOW())
    

    How can I set the second or third ? via script or meta data point?
    My solution with an alphanumeric mds-point doesn't work:

    var myVar = myIDNr.value + ',' + myStartSum.value + ',' + myStartTemp.value;
    var myString = myVar.toString();
    print(myString)
    if ( myStart.value == true )
        mySQL.set ( myString.value );
    

    What is the best solution?

    Thanks for your help.


  • @ralf said in SQL Data Source Insert and Update rows:

    INSERT INTO table_xz (
    IDNr, StartSum, StartTemp, ValveNr, LineNr, StartTime)
    VALUES (?,?,?,'KS0717','B',NOW())

    I know you can extend the insert query by just adding another batch of values after in brackets.

    INSERT INTO table_xz (
    IDNr, StartSum, StartTemp, ValveNr, LineNr, StartTime) 
    VALUES (?,?,?,'KS0717','B',NOW()),(?,?,?,'KS0717','B',NOW())
    
    

    You may need to insert the actual values though.