after update trigger in mysql on same column

Posted by Shanky11 under Others on 8/28/2012 | Points: 10 | Views : 2841 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

create trigger trg_updt
after update on product
for each row
begin
update product set total=price+vat;
end;
table name=product
pid pname price vat total
1 ball 50 25 75
2 bat 85 15 100
i want when i run ---------update product set vat=20 where pid=2;
question.......it should automatically update total by trigger

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Nkkppp on: 8/28/2012 [Member] Starter | Points: 25

0	Hi Shanky11, Below is the trigger code for update on product table create trigger Trg_Product_Update on product for update as begin set nocount on declare @vat int,@price int,@pid int select @vat=vat,@price=price,@pid=pid from inserted update product set total=@price+@vat where @pid=pid end Prathap, if this helps please login to Mark As Answer. Regards, Prathap. Shanky11, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Shanky11,

Below is the trigger code for update on product table

create trigger Trg_Product_Update on product for update

as 

begin

set nocount on

declare @vat int,@price int,@pid int

select @vat=vat,@price=price,@pid=pid from inserted

update product set total=@price+@vat where @pid=pid

end

Prathap, if this helps please login to Mark As Answer.

Regards,
Prathap.

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts