mysql query

sailu_mvn · 04-06-2006, 04:06 AM

I have two tables. Both the tables contain a same field called 'number'. When that field is updated in table1, the same field in table2 should also get auomatically updated.
Can anyone suggest me how to go about with this query?

thermite_1033 · 04-06-2006, 05:27 AM

use a trigger

Code:

create trigger tr_update
after update of number on tabel1
begin
update table2
set number=:new.number
where number=:old.number

end tr_update

this syntax is used in oracle maybe you need to change something=> look it up in the mysql manual for the wright syntax

i never tried a trigger in mysql yet, maybe tomorow i'll go have fun with using triggers