update row if already exists in mysql

Question

I have a table in mysql like this

Name              Result  
T1_09_03_2010     fail  
T2_09_03_2010     pass  
T3_09_03_2010     pass  
T4_09_03_2010     fail  
T5_09_03_2010     fail  
T6_09_03_2010     pass  
T7_09_03_2010     fail

Well, T1_09_03_2010 is testcase name. If for some reason the developer wants to test the same testcase again in the same day, using the same name then, I need a way to update the already existing row based on the result. Say , for example T1_09_03_2010 has failed in this context and if this is run again and the result is pass, it should update the row, but if the result if fail, then it should leave the result as it is I mean ignore the new insert and carry on with others.

Thanks.

Answer 1

here is an example syntax for mysql:

INSERT INTO users (username, email) VALUES ('Jo', '[email protected]')
ON DUPLICATE KEY UPDATE email = '[email protected]'

Answer 2

You should use the INSERT... ON DUPLICATE KEY UPDATE .. syntax.