CodePudding user response:

How to write SQL statements to implement this function

CodePudding user response:

Note: more than the two columns, thousands of column, probably is to change id to the id in table A in table B

CodePudding user response:

 update bThe set b.i d=Anderson d 
From table B as inner B as A on the join list A b.t itle=a.t itle 

Your description is not clear, the picture is not easy to write code,
You see is what you want,

CodePudding user response:

reference gypsy song reply: 3/f

 
 update bThe set b.i d=Anderson d 
From table B as inner B as A on the join list A b.t itle=a.t itle 

Your description is not clear, the picture is not easy to write code,
You see if you want,

Thank you QWQ????????