After around two SQL, as shown in figure on table swap count query result is different, very curious will produce the reason of this result,

CodePudding user response:

This explanation, is the data changes,

CodePudding user response:

You here a and b data is different, you can put the count (*) to *, see what content is different,