database-trigger – Tarik Billa

MySQL – Trigger for updating same table after insert

September 11, 2023 by Tarik

It seems that you can’t do all this in a trigger. According to the documentation: Within a stored function or trigger, it is not permitted to modify a table that is already being used (for reading or writing) by the statement that invoked the function or trigger. According to this answer, it seems that you … Read more

How to disable triggers in MySQL?

September 4, 2023 by Tarik

Its not possible to temporarly disable triggers. Do one thing, use one global variable. Trigger will first check value of global variable first. In this case you can change value of global variable to prevent working of trigger.

Create or replace trigger postgres

January 16, 2023 by Tarik

No way to create or replace a trigger but can do this way DROP TRIGGER IF EXISTS yourtrigger_name on “yourschemaname”.”yourtablename”;