Skip to main content
1 of 6

If ts1 is declared as unique, you can add a foreign key in table2 with ON UPDATE CASCADE.

If not, you can add a trigger that does the update.

However, there is something unsatisfactory with a key that change frequently. Consider redesigning your model