MariaDB replace 0

Question

Are there opportunities for rules to replace 0 value by values of another dataset? That before eg?

Answer 1

The question is not quite clear. MariaDB syntax is very similar to Mysql. Do you want to show a different value when querying tables (SELECT)? If so, you can JOIN another table and use a CASE operator in your query. If you want to replace NULL values, you can also take advantage of IFNULL and COALESCE functions.
https://mariadb.com/kb/en/case-operator/
https://mariadb.com/kb/en/ifnull/
https://mariadb.com/kb/en/coalesce/

Or you want to change the value when it is inserted into a table? Then a TRIGGER can help you.
https://mariadb.com/kb/en/trigger-overview/

Answer 2

Thanks Tibor Santa !
A set of opportunities is always 👌