Re: trigger with condition

[Martin Tomczyk]

Thanks Peter,

I have some questions back:

1. how to check if it refers to it or not? The update I posted is running and updating the mentioned id and I get no errors.
2. Join is missing the joining condition. OK. I need to set it....
but I don't understand your code. The needed id's 1 and 2 are missing so I wonder how it could update correctly? The trigger should "touch" only this two id's.
The purpose is to "sync" one field from one table to the other. exclusively these two id's. one on source the other one on destination. the id's are fix and different in each table. so they do not match and also should not. the id's itself should not be updated only the introtext of these id's.
You mentioned NEW/ OLD regarding trigger. I'm not sure know if understood the manual correctly but there should never be any new rows created. only the one that exists should be updated with content of the other. but only the field introtext...nothing else.

And the trigger should not 2sync" these two id's if antoher source id is edited but only if source.id=1 is changed.

Quote from manual: In an UPDATE trigger, you can use OLD.col_name to refer to the columns of a row before it is updated and NEW.col_name to refer to the columns of the row after it is updated.
Does this mean NEW.col_name is in real my "old"/source field?


I thought that I described it well but I must have missed something. What info do you need to help me out ? :) btw it is mysql 5.0.90 underneath (update planned but I need it running on this version).

Peter, thanks a lot for your help. I really appreciate it. Sorry if I describe things a little bit confusing. I do my best.
Best regards
Martin



Edited 1 time(s). Last edit at 11/29/2013 02:24PM by Martin Tomczyk.