mysql - How to update value for all rows in table A should update all corresponding column values in table b and c -


i need update column x different value each record in table of 60 records, , when update column in table ,the column value particular column x must updated in table b , table c column x value. here column x primary key in table b , c not in table a.

this triggers for.

an example taken documentation:

mysql> create table account (acct_num int, amount decimal(10,2)); query ok, 0 rows affected (0.03 sec)  mysql> create trigger ins_sum before insert on account     -> each row set @sum = @sum + new.amount; query ok, 0 rows affected (0.06 sec) 

this example not modify second table, can done triggers well--possibly using stored procedure.


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -