Comparison of query in datetime format in MySQL time period-easy to make mistakes _ MySQL

Comparison of query in datetime format in MySQL time period-error-prone solution bitsCN.com

Comparison of query in datetime format in MySQL time period-easy to make mistakes

Query in datetime format in MySQL time period-prone to mistakes

1. query all data on the 10th:

2. query all data on November 11:

3. query all data on the 10th and 11th

In the query of a date segment, remember that the following date must be added for one day. equal signs cannot be used. equal signs indicate 00:00:00 of the day.

BitsCN.com