Masters ~ ~ to ask you a question,
I this table should be based on the C column (yellow), the D column (red) is not NULL data replacement to the C column,
How MySQL code, table joins seemed to solve the problem of no replacement,

CodePudding user response:

 update tableName 
The set C=D 
Where D is the not null