mysql and global constant

Question

MySQL

There is a Mysql base, which has a large number of triggers. In some of them, you need to write data from a constant so that it is used in calculations for all calls to these triggers. How and where is it better to write it down. The easiest way is to write the value of the constant directly in the trigger, but if it changes, it is not desirable to rewrite the value in dozens of triggers.

Answer 1

Write a function that will return the value of a constant. In this case, when changing the value, only this function will need to be changed.