Unfortunately, MySQL does not offer an ALTER TRIGGER function. To edit an existing trigger, you must first delete it and then regenerate it. The CREATE TRIGGER statement can be indirectly accessed via the information_schema . This allows us to modify triggers indirectly. To do this, make your changes in the result of the following SELECT command (after changing the database and trigger names) and execute the query.
734f80792453bf24a6d7b04f78949529