mysql--when a query encounters hidden characters

Tag: JPG causes condition to return VIM port data log input

Cause of event:

When you import some Excel-maintained data into MySQL during maintenance, you find that some data is missing, and when you check it, you see that the same SQL returns completely differently:

See in the SQLyog as:

Two SQL execution results are different, one of the SQL Wms_report1 is keyboard input, and the other SQL Wms_report1 is copied and pasted from the database.

Using Xshell to connect to MySQL, the same problem occurs when you copy SQL to Xshell, but there is no way to see the difference between the two sql:

Problem solving:

After colleagues remind, copy SQL to Vim to see, finally found clues:

By copying and pasting, the hidden characters are brought into the where condition, resulting in seemingly identical SQL having different results

##===========================================================================================##

Still the sister is affixed

mysql--when a query encounters hidden characters