三种方法匹配日期

• like
• year(date)='2021' month(date)='08'
• date_format(date,'%Y-%m')='2021-08'

# select count(distinct device_id) as did_cnt,count(question_id) as question_cnt from question_practice_detail
# where date like '%2021-08%';

##第二种办法
# select count(distinct device_id) as did_cnt,count(question_id) as question_cnt from question_practice_detail
# where YEAR(date)='2021' and MONTH(date)='08';

##第三种办法
SELECT count(distinct device_id) as did_cnt,count(question_id) as question_cnt from question_practice_detail
where DATE_FORMAT(date,'%Y-%m')='2021-08';