Re: triggers- how to bring updates in one table to another table

[Alexander Kolesen]

CREATE TRIGGER sync_t 
AFTER UPDATE ON table1
FOR EACH ROW
UPDATE table2 
SET name = NEW.name WHERE id = NEW.id;

> i have two tables namely.. table1 and table2, table1 and table2 have the two
> columns samely like id and name, by using triggers i have to bring the
> updates in table1 to table2, if i updated name in table1 trigger has to made
> the same up date for table2. please help me regarding this.
> thnaks in advance