How to traverse the query results and update the results to another table in the mysql stored procedure

Result set found by SQL :! When the result is queried, return to the memberid((img.ask.csdn.netupload201604111460334280_418554.jpg) table: t_bm_integral! The SQL statement in the first figure shows that a result set contains the memberid and integral fields. now we need to traverse and store in... mysql in this result set.

Result set found by SQL:

Table: t_bm_integral

The SQL statement in the first figure shows that a result set contains the memberid and integral fields. you need to insert or update the integral field in the result set to the table in the second figure (table name: t_bm_integral) of the integral field (if the memberid in the first graph exists in the second graph, update its integral, if this field does not exist, insert the first mongomemberid and integral fields as a new record.) how do I write stored procedure statements?