Have you used the mysql strict mode? Let's take a look at the problem with this simple SQL statement?

Have you used the mysql strict mode? In addition, I found a problem: {code ...} the information can also be correctly queried. The value is clearly not followed by so many spaces after 12345. Why can we also find out if we add a lot of spaces? We accidentally know that there is a strict mode in mysql, I don't know... have you used the mysql strict mode?

In addition, I found a problem:

Select * from tb_test where value = '20140901 ';

The information can also be correctly queried. The value is clearly not followed by so many spaces after 12345. Why can we also find out if we add a lot of spaces? We accidentally know that there is a strict mode in mysql, I don't know if it's not strictly related?

Reply content:

Have you used the mysql strict mode?

In addition, I found a problem:

Select * from tb_test where value = '20140901 ';

The information can also be correctly queried. The value is clearly not followed by so many spaces after 12345. Why can we also find out if we add a lot of spaces? We accidentally know that there is a strict mode in mysql, I don't know if it's not strictly related?

Your value field should be of the char type. char is of the fixed length. You should be of the char (9) type)