asked on
Trigger To Update A Field When Field In Another Table Is Changed
I have a mysql database and I want a Trigger To Update A Field When Field In Another Table Is Changed.
Table 1 = cases_cstm and Table 2 = Contracts
I have an End date field in both tables.
The Field name under cases_cstm is enddate_c
The field name under Contracts is end_date
I would like when a Case is created to copy the End date from Contracts to Cases
Table 1 = cases_cstm and Table 2 = Contracts
I have an End date field in both tables.
The Field name under cases_cstm is enddate_c
The field name under Contracts is end_date
I would like when a Case is created to copy the End date from Contracts to Cases
MySQL ServerDatabasesDB Reporting Tools
Last Comment
NerdsOfTech
Review your model. This is redundancy at its best.
ASKER
I don't understand your comment?
Normalization. Why copying a value at all? This value should be stored only once.
ASKER
Cause I need to display the same date in 2 different views. one in Cases and one in Contracts.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.