The MySQL stored procedure---involves the association between multiple tables, and each table has the same field, with the primary key ID as an example, be sure to use xx.id to differentiate

This article does not place the stored procedure instance.

This is the most time-consuming problem I have encountered in developing a stored procedure, and the stored procedure can run, but the result is not what you want,

For a long time, it was found that the ID in this sentence was a curse: SET projectinfoid = (SELECT ID from temp. Project_info p WHERE 1=1 and p.issue_key = Projectkey);

Change to p.id is OK.

To develop good habits, remember to use the X.XX format when writing, and avoid unnecessary errors.

The MySQL stored procedure---involves the association between multiple tables, and each table has the same field, with the primary key ID as an example, be sure to use xx.id to differentiate