mysql triggers

Kirinyet Brian — Wed, 02 Sep 2020 10:35:56 +0000

Hello. I need 2 small triggers written. Now before you tell me I could just run a join in my select query to get what I'm looking for, other limitations not in my control will not allow me to do so. So, I need to get creative...

Trigger 1:
On insert into the Contact table, I need a trigger to copy the ExternalId from the Company related to a new contact record to the CompanyExtId field on the Contact.

On update of an existing record in the Contact table, I need a trigger to copy the ExternalId from the (potentially updated) Company related to the updated contact record to the CompanyExtId field on the Contact.

Here is an example schema:
create TABLE Company (Id int auto_increment, Name char(20), ExternalId char(20), PRIMARY KEY (Id));
create TABLE Contact (Id int auto_increment, FirstName char(20), LastName char(20), CompanyExtId char(20), PRIMARY KEY (Id));

DEV Community: Kirinyet Brian

mysql triggers