<div>
Review your model. This is redundancy at its best.
</div>


Review your model. This is redundancy at its best.

<div>
I don't understand your comment?
</div>


<div>
<a href="http://en.wikipedia.org/wiki/Database_normalization" rel="ugc">Normalization</a>. Why copying a value at all? This value should be stored only once.
</div>


Normalization [http://en.wikipedia.org/wiki/Database_normalization]. Why copying a value at all? This value should be stored only once.

<div>
Cause I need to display the same date in 2 different views. one in Cases and one in Contracts.
</div>


Cause I need to display the same date in 2 different views. one in Cases and one in Contracts.

<div>
<div class="content wysiwyg-content">
I have a mysql database and I want a Trigger To Update A Field When Field In Another Table Is Changed.<br />
<br />
Table 1 = cases_cstm and Table 2 = Contracts<br />
I have an End date field in both tables.<br />
The Field name under cases_cstm is enddate_c<br />
The field name under Contracts is end_date<br />
<br />
I would like when a Case is created to copy the End date from Contracts to Cases
</div>
</div>


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

Trigger To Update A Field When Field In Another Table Is Changed

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.