mysql-error-1442
ERROR 1442: Can't update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
I have a table that I want : when the table has been updated, 2 fields of that (title and description) change and take value from another table[详细]
2023-03-14 08:49 分类:问答MySql Triggers to delete child records in the same table
I have a table t开发者_StackOverflow社区hat stores parent and child records in it. I was trying to create a trigger that would delete all child records when the parent is deleted:[详细]
2023-03-03 11:12 分类:问答MySQL: How to create trigger for setting creation date for new rows
I ran into a problem as I tried to create two TIMESTAMP columns in my database. One called created and one called updated. I figured it would be easy to set the default value of both to CURRENT_TIMEST[详细]
2023-01-01 04:36 分类:问答mysql trigger stored trigger is already used by statement which invoked stored trigger
I want to set up a trigger so that if on an update the prediction field is = 3 then the trigger changes the value to 4 and saves it in the database. The trigger is below.[详细]
2022-12-08 14:42 分类:问答