Use MySQL trigger to update another table when duplicate key found
- by Jason
Been scratching my head on this one, hoping one of you kind people and direct me towards solving this problem.
I have a mysql table of customers, it contains a lot of data, but for the purpose of this question, we only need to worry about 4 columns 'ID', 'Firstname', 'Lastname', 'Postcode'
Problem is, the table contains a lot of duplicated…