how can I update one cell in mysql table after classification (to give feedback to labview) ?

dkpengqiuyang
dkpengqiuyang New Altair Community Member
edited November 2024 in Community Q&A

I use labview to get test data and store them in mysql, and mysql file update will triger rm server and run the classification program, finally I need to feedback the prediction data (OK, NG) to labview, right now I have 2 ways to do these, I wonder if there is another way to give feedback to labview program, thanks:

 

1)generate new attribute

1.1)labview store data into mysql, insert 4 columns, which are "prediction(OK/NG)", "confidence(OK)", "confidence(NG)", and "feedback", into the test data table, 

1.2)remove "feedback" column,

1.3)run classification program,

1.4)generate new attribute "feedback"( feedback = prediction )

1.5)update mysql table

1.6)labview read mysql table

 

2)sql update

2.1)labview store data into mysql as table 1, insert "feedback"

2.2)run classification program,

2.3)store program result into mysql as table 2

2.4)use sql update "feedback" in table 1 by cross update table 1 and table 2

Best Answer

  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    Hi,

     

    you could run an Execute SQL command with specific command if you are that cost sensetive.

     

    Best,

    Martin

Answers

  • MartinLiebig
    MartinLiebig
    Altair Employee

    Hi,

     

    did you check the Update Database operator?

     

    ~Martin

  • dkpengqiuyang
    dkpengqiuyang New Altair Community Member
    yes I try the update database in way 1, that is way I need to generate 3 attributes, and it update the whole table :(
  • dkpengqiuyang
    dkpengqiuyang New Altair Community Member
    I prefer way 2 for it cost less resource
  • MartinLiebig
    MartinLiebig
    Altair Employee
    Answer ✓

    Hi,

     

    you could run an Execute SQL command with specific command if you are that cost sensetive.

     

    Best,

    Martin