Mysql can according to the value of A field, modify the default value of the corresponding fields, such as A table, there are two fields m, n, when m is 1, the default is 0 n
When m is 2 n is empty,

CodePudding user response:

Can't, but can be used before the insert trigger similar effect,