Click here to Skip to main content
14,970,418 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have four tables where 3 tables inherit from 1. now what i want to do is insert into the one and at the same time update the table that might be involved. Furthermore its basically an account table that is the parent of a loanAccountTable,savinggsAccount Table and a chequeAcountTable. is it possible in mysql?

thanks in advance

1 solution

Triggers[^] is your answer. You setup a trigger on the Account Table, that updates all other related tables

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900