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
Post a Comment