Hi "A" table (sipid,totalkg) 1 .. 2.. 3.. "B" table (id,sipid,kg) 1 1 500 2 1 200 3 2 150 I want similer sipid B table total kg value add A table totalkg Please help me
I have written a detailed article on MySQL triggers http://programmerblog.net/create-mysql-trigger-php/ hope it helps you and any other.