ODBC MYSQL UPDATE LOGGING

[ericm]

High all
I am using the folloiwing sql to update the results of my tests to a mysql db. I wish to only update if the test exist all ready. If it doesn't exist then insert. (As you will see in my statement.) Anyways it does not update if the test exist all ready. It is always inserting.

NSERT INTO metrics (testdate,folder,testname,alive) VALUES (NOW(), '%Folder%', '%TestName%', '%AliveRatio%') ON DUPLICATE KEY UPDATE testdate=NOW(), folder='%Folder%',testname='%testname%',alive='%AliveRatio%'

[KS-Soft Europe]

It is always inserting.

Correct.

NSERT INTO metrics (testdate,folder,testname,alive) VALUES (NOW(), '%Folder%', '%TestName%', '%AliveRatio%') ON DUPLICATE KEY UPDATE testdate=NOW(), folder='%Folder%',testname='%testname%',alive='%AliveRatio%'

"AliveRatio" is changed every time the test has been performed, so DUPLICATE KEY UPDATE wil not work in such case. Try to use following syntax:

Code: Select all

INSERT INTO metrics (testdate,folder,testname,alive) VALUES (NOW(), '%Folder%', '%TestName%', '%AliveRatio%') ON DUPLICATE KEY UPDATE  testdate=NOW(), folder='%Folder%',testname='%testname%'

It might help.

Regads,
Max