Batch update mysql a column values, such as the name column of the original value of 1, 2, 3... Updated to a, b, c... ...

CodePudding user response:

Always associated with conditions, I need to change the data row,

CodePudding user response:

The name is a value of 1, 2, 3 can use this to SELECT ELT (name, 'a', 'b', 'c'... ); If the name is a string or in case the when