I want to do a trigger on a table, when the table to insert a data that meet specific criteria, update the data in certain fields,
When inserted into the UID=521519, for example, if the G column contains? G substitution, automatically put the data into a UID=521480 G column, if you don't have? Number, while maintaining the original data,

CodePudding user response:

You can refer to my blog:
https://blog.csdn.net/yenange/article/details/85126707