Why use concat splicing execution cannot be changed after field coding, but separate write a statement can change the field coding? The alter, for instance, the modify a3,,, can be successfully executed change

CodePudding user response:

You are using the exec to perform dynamic statement? If so, mysql does not support multiple words
General mysql pipe solution
Mysql - e "generates SQL query" -- the skip - column - names | mysql