Mysql trigger now have in such a demand,
X to insert data in the table when triggered,
And modify the article a meet the conditions of the data in the table,
Example: the tree to add child nodes colleagues to path to assign a value to the parent node,
1 is update this table in mysql does not support the trigger, 2 is no parent node in the new data
What to do with this case, is there any good method?

CodePudding user response:

Make an auxiliary table, transit

CodePudding user response:

How to transfer didn't do it, can you take a chestnut

1/f, reference to learning turn _ response:

have a auxiliary table, transfer the