Table jys_coin_address one of the fields for in_address
Table is_activate jys_user_info including field defaults to 1,
Two table id associated
Requirements: as long as In_address field is a set of known addresses (such as "a", "b", "c") in an arbitrary value, use the corresponding id to check jys_user_info In_address the corresponding data table, and update the actual orderdate is_activate is 0,

I know it needs to write a stored procedure and a timing task to achieve, consult database Daniel to give directions?

CodePudding user response:

Solution, the original so simple

CodePudding user response:

Congratulations to , the original poster can stick after solve the code, let us see if there are other better way

CodePudding user response:

First write anything, it is suggested that direct copy from the manual ready, then ensure that the same copy to code can run correctly add your own code to their products on the basis of logic,