mysql执行临时查看添加limit 10
select * from msg_info cc WHERE DATE_FORMAT(cc.CREATE_DATE,'%Y%m%d') = '20231127';
> 1025 - [xx_dql_where]DQL语句需要增加where条件;[xx_dql_explain]DQL语句影响行数不能超过20000,当前值180906;
> 时间: 0.021s
select * from msg_info cc
WHERE 1=1
and cc.CREATE_DATE < '2023-11-28 00:00:00'
and cc.CREATE_DATE > '2023-11-27 00:00:00'
and cc.CREATE_DATE is not null